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 :) |
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 :) |
All times are GMT +1. The time now is 09:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com