Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a splash screen to an excel add-in causes double-clicking to not work
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 ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a splash screen to an excel add-in causes double-clicking to not work
Mike
This is purely a guess, but try going to Tools - Options and uncheck Ignore Other Applications. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Mike Sealock" wrote in message ... 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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Excel by double-clicking a file doesn't work! | Excel Discussion (Misc queries) | |||
Splash Screen | Excel Discussion (Misc queries) | |||
splash screen | Excel Discussion (Misc queries) | |||
Double clicking Field does not work anymore in Pivot Table... | Excel Discussion (Misc queries) | |||
Worksheet Scrolls screen length when double-clicking between cells | Excel Discussion (Misc queries) |