UserForms and double-clicked worksheets...

[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

[Tom Ogilvy]

Have you tried showing it as a modeless form?

--
Regards,
Tom Ogilvy

"Dan" <Dan@discussions.microsoft.com> wrote in message
news:53BB0C67-E013-41E0-87D1-53A7B70E531D@microsoft.com...
> 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