M
Mike Sealock
I added an extremely simple "splash screen" to my excel
add-in via the following code
-----------------------------------------------
Public Auto_Open()
' remove the splash screen 2 seconds from now
Application.OnTime Now + TimeValue
("00:00:02"), "HideSplash"
frmSplashScreen.Show
Private Sub HideSplash()
Unload frmSplashScreen
End Sub
-------------------------------------------------
Now when I double click on any workbook (.xls) from the
Windows Explorer, it will not open, all I get is a blank
screen. The add-in has sucessfully loaded, the splash
screen came up and went away after 2 seconds like it was
suppose to.
If I comment out the line of code in the Auto_Open, then
duble-clicking works fine
Any ideas ?
add-in via the following code
-----------------------------------------------
Public Auto_Open()
' remove the splash screen 2 seconds from now
Application.OnTime Now + TimeValue
("00:00:02"), "HideSplash"
frmSplashScreen.Show
Private Sub HideSplash()
Unload frmSplashScreen
End Sub
-------------------------------------------------
Now when I double click on any workbook (.xls) from the
Windows Explorer, it will not open, all I get is a blank
screen. The add-in has sucessfully loaded, the splash
screen came up and went away after 2 seconds like it was
suppose to.
If I comment out the line of code in the Auto_Open, then
duble-clicking works fine
Any ideas ?