Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Splash Screen
Hi,
Could anyone help out witht he following. I'm trying to create a splash screen (easy enough) but show it for say 5 secs before the first worksheet in excel actually appears (I dont mind excel opening but I'd like to show the splash screen before any worksheets are visible. Is this possible?? Thanks Martin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Splash Screen
So, is the question how to show it for 5 secs, or how to make no worksheets
visible? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Martin Parker" <Martin wrote in message ... Hi, Could anyone help out witht he following. I'm trying to create a splash screen (easy enough) but show it for say 5 secs before the first worksheet in excel actually appears (I dont mind excel opening but I'd like to show the splash screen before any worksheets are visible. Is this possible?? Thanks Martin |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Splash Screen
the question is how to make no worksheets visible...sorry for the confusion!
"Bob Phillips" wrote: So, is the question how to show it for 5 secs, or how to make no worksheets visible? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Martin Parker" <Martin wrote in message ... Hi, Could anyone help out witht he following. I'm trying to create a splash screen (easy enough) but show it for say 5 secs before the first worksheet in excel actually appears (I dont mind excel opening but I'd like to show the splash screen before any worksheets are visible. Is this possible?? Thanks Martin |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Splash Screen
I don't believe macros run until the workbook is completely loaded.
"Martin Parker" wrote: the question is how to make no worksheets visible...sorry for the confusion! "Bob Phillips" wrote: So, is the question how to show it for 5 secs, or how to make no worksheets visible? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Martin Parker" <Martin wrote in message ... Hi, Could anyone help out witht he following. I'm trying to create a splash screen (easy enough) but show it for say 5 secs before the first worksheet in excel actually appears (I dont mind excel opening but I'd like to show the splash screen before any worksheets are visible. Is this possible?? Thanks Martin |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Splash Screen
The workbook will load and then the macro starts, so you will have to make
the active window non-visible right at the start of the code. The window will flash up briefly, but best I can think of. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Martin Parker" wrote in message ... the question is how to make no worksheets visible...sorry for the confusion! "Bob Phillips" wrote: So, is the question how to show it for 5 secs, or how to make no worksheets visible? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Martin Parker" <Martin wrote in message ... Hi, Could anyone help out witht he following. I'm trying to create a splash screen (easy enough) but show it for say 5 secs before the first worksheet in excel actually appears (I dont mind excel opening but I'd like to show the splash screen before any worksheets are visible. Is this possible?? Thanks Martin |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Splash Screen
Hi,
The problem now is when the workbook opens, nothing is visible, no splash screen or worksheets. I'm not sure what i've done and cant figure out how to get back to where i was originally. i typed 'activewindow.visible = false' as the first routine under workbook open. I've now deleted the code but nothing appears anymore. Hope you can help! "Bob Phillips" wrote: The workbook will load and then the macro starts, so you will have to make the active window non-visible right at the start of the code. The window will flash up briefly, but best I can think of. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Martin Parker" wrote in message ... the question is how to make no worksheets visible...sorry for the confusion! "Bob Phillips" wrote: So, is the question how to show it for 5 secs, or how to make no worksheets visible? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Martin Parker" <Martin wrote in message ... Hi, Could anyone help out witht he following. I'm trying to create a splash screen (easy enough) but show it for say 5 secs before the first worksheet in excel actually appears (I dont mind excel opening but I'd like to show the splash screen before any worksheets are visible. Is this possible?? Thanks Martin |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Splash Screen
You probably saved the workbook when it wasn't visible. Open it in excel,
then go to the VBE and execute code to make it visible. Then save it. (or go to the window menu and then unhide, select it and click OK) -- Regards, Tom Ogilvy "Martin Parker" wrote: Hi, The problem now is when the workbook opens, nothing is visible, no splash screen or worksheets. I'm not sure what i've done and cant figure out how to get back to where i was originally. i typed 'activewindow.visible = false' as the first routine under workbook open. I've now deleted the code but nothing appears anymore. Hope you can help! "Bob Phillips" wrote: The workbook will load and then the macro starts, so you will have to make the active window non-visible right at the start of the code. The window will flash up briefly, but best I can think of. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Martin Parker" wrote in message ... the question is how to make no worksheets visible...sorry for the confusion! "Bob Phillips" wrote: So, is the question how to show it for 5 secs, or how to make no worksheets visible? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Martin Parker" <Martin wrote in message ... Hi, Could anyone help out witht he following. I'm trying to create a splash screen (easy enough) but show it for say 5 secs before the first worksheet in excel actually appears (I dont mind excel opening but I'd like to show the splash screen before any worksheets are visible. Is this possible?? Thanks Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a splash screen in excel | Excel Programming | |||
Create an Excel splash screen without the caption bar | Excel Programming | |||
Splash screen and various screen resolutions | Excel Programming | |||
Splash screen on opening excel | Excel Programming | |||
Adding a splash screen to an excel add-in causes double-clicking to not work | Excel Programming |