ExcelBanter - Excel Splash Screen

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel Splash Screen (https://www.excelbanter.com/excel-programming/382739-excel-splash-screen.html)

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

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

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

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

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

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