Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForms and double-clicked worksheets...
Hi all,
I have a macro that is loaded (via the XLSTART directory) which first displays a splash-screen using a UserForm and an OnTime event to close it after a couple of seconds. This works fine. However - if I start Excel by double-clicking on an .XLS sheet via Explorer, Excel starts, my first worksheet loads (with it's macro), I get my pretty splash screen, it closes, but the file I double-clicked on DOES NOT load. If I use a MsgBox instead of a UserForm it works correctly. Both worksheets load. If I remove my macro worksheet from the XLSTART directory (or even just disable the UserForm), the double-clicked file loads correctly. If I start Excel via a shortcut, my macro worksheet loads and I can then manually open the required worksheet via [file], [open], etc... and this works too. Does anyone know why UserForm appears to stop Excel loading any worksheets at application startup? I would rather use a UserForm instead of a MsgBox as a UserForm can be made to look nicer... (grin) Thanks! Dan :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForms and double-clicked worksheets...
Have you tried showing it as a modeless form?
-- Regards, Tom Ogilvy "Dan" wrote in message ... Hi all, I have a macro that is loaded (via the XLSTART directory) which first displays a splash-screen using a UserForm and an OnTime event to close it after a couple of seconds. This works fine. However - if I start Excel by double-clicking on an .XLS sheet via Explorer, Excel starts, my first worksheet loads (with it's macro), I get my pretty splash screen, it closes, but the file I double-clicked on DOES NOT load. If I use a MsgBox instead of a UserForm it works correctly. Both worksheets load. If I remove my macro worksheet from the XLSTART directory (or even just disable the UserForm), the double-clicked file loads correctly. If I start Excel via a shortcut, my macro worksheet loads and I can then manually open the required worksheet via [file], [open], etc... and this works too. Does anyone know why UserForm appears to stop Excel loading any worksheets at application startup? I would rather use a UserForm instead of a MsgBox as a UserForm can be made to look nicer... (grin) Thanks! Dan :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel files not opening when double clicked | Excel Discussion (Misc queries) | |||
Excel "can't find" double-clicked files | Excel Discussion (Misc queries) | |||
Formula not displaying colored border when double clicked | Excel Discussion (Misc queries) | |||
Change cell value when right-clicked/double-clicked | Excel Programming | |||
VB6, How do i open (instead of edit) an excel OLE doc when it is double clicked? | Excel Programming |