Excel Splash Screen

M

Martin Parker

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
 
B

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)
 
M

Martin Parker

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

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)
 
M

Martin Parker

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!
 
T

Tom Ogilvy

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top