View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Splash Screen Causing Problems

If the splash screen appears, the file is open. Perhaps it is hidden. If
so, unhide it with your code.

--
Regards,
Tom Ogilvy


"Kevin R" wrote in message
...
I have an xla file that contains a splash screen (userform) in the
workbook_open event. This seems to be causing a problem when opening

files
directly from windows explorer. If Excel is closed and I open a file

through
windows explorer, the splash screen appears but the xls file does not

open.
I have to open all files using the File | Open method or first open Excel

and
then open the files through windows explorer. If I take out the splash
screen I don't have the problem. Any ideas or suggestions on how to

correct
this so that files can be open directly from explorer without having to

first
open Excel? Thanks.