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.
|