UserForms and double-clicked worksheets...

D

Dan

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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet appears briefly before UserForm opens 4
Load Userform on Workbook_Open()?? 1
Always on top and Deactivate event 0
Keep Cell Unlocked but Don't Allow User to Change the Text in Cell 8
Find Date cell using Calendar Control 1
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
Hiding a "Userform" instead of closing it??? 4
Menu Macro Not Executing - Need Help 1

Top