Workbook_Open
 

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.

Workbook_Open
 

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

--
Regards,
Tom Ogilvy

"Kevin R" wrote in message
...
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.

Workbook_Open
 

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

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy

"Kevin R" wrote in message
...
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.

Workbook_Open
 

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.

--
Regards,
Tom Ogilvy



"Kevin R" wrote in message
...
I checked that and it's not checked. Any other suggestions?

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy

"Kevin R" wrote in message
...
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.

Workbook_Open
 

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.

"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy



"Kevin R" wrote in message
...
I checked that and it's not checked. Any other suggestions?

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy

"Kevin R" wrote in message
...
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.