View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin R Kevin R is offline
external usenet poster
 
Posts: 27
Default Splash Screen Causing Problems

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.