Excel Splash Screen

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
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)
 
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!
 
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)
 
Back
Top