Iphone

When an internet website displays an excel spreadsheet, IE 7 checks Excel's current status.

Situation 1: If windows already has an instance of Excel, IE will use that instance,
Situation 2: If the are not instances of Excel IE will create a new instance which will therefore load Personal.xls.

My problem occurs in Situation 2. If the user leaves the IE window open, then clicks on QuickLaunch to open Excel, a NEW instance of excel is launched. Since Personal.xls is already loaded under IE, The new instance will insist on a read only open of Personal.xls. One idea I had was to have the workbook open detect that it is under IE, and then close personal.xls. That causes IE to immediatlely crash as soon as IE instance opens personal.xls
Microsoft Office Excel has encountered a problem and needs to close...
sub workbook_open
thisworkbook.close
end sub

Does anybody have any ideas? For instance, is there file association that will tell IE to launch an Excel Viewer instead of the full Excel?

Iphone

Try setting the IsAddin property to True. This forces ALL instances of Personal.xls to be opened as read-only. To do so, press ALT-F11, open the ThisWorkbook module in the Personal.xls project, press F4, and change the IsAddin property to True.