Excel Splash Screen

[Guest]

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

 

[Bob Phillips]

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)

 

[Guest]

the question is how to make no worksheets visible...sorry for the confusion!

 

[Guest]

I don't believe macros run until the workbook is completely loaded.

 

[Bob Phillips]

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)

 

[Guest]

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!

 

[Guest]

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)