Workbook_Open

[Guest]

I created a Sub Workbook_Open that opens a user form (splash screen) and
builds a toolbar each time Excel is open. However, if I try to open an xls
file thru My Computer or Windows Explorer, it doesn't open. Excel opens,
shows the splash screen, and builds the toolbar but the document never opens.
I have to click File | Open to get it open. Any ideas why? Thanks.

 

[Tom Ogilvy]

Look in Tools=>Options=>General tab and make sure Ignore Other Applications
is not checked.

 

[Guest]

I checked that and it's not checked. Any other suggestions?

 

[Tom Ogilvy]

The other common suggestion is to reregister excel

excel.exe /regserver


from a previous post by Dave Peterson

Close Excel (all instances) and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

 

[Guest]

That didn't work either. The Sub Workbook_Open is in an add-in that loads
when Excel opens. For some reason this isn't allowing the file to open when
its double clicked in Explorer.