Splash Screen opens after document

[JIBG]

I have a Excel document that may take as much as 8 seconds to open in our company old hardware, I made a Splash screen to open when the workbook open, but it does it after the workbook opens. How can I make the Splash screen to open first and then the workbook so the intended recipients can be distracted while the workbook opens. I would like the workbook to open in a small size window behind the Splash screen while the workbook open, so the only object visible will be the splash screen until the workbook opens and then will open to a determinate window size (don’t want to open all the way until the user clicks the first object on the Main sheet). Also what is the best code for slow fade out.

[Steven_Daniel]

Hello JIBG

When you open your excel workbook, you cannot stop Microsoft Excel from showing as you need to get the user to confirm whether they want to Enable Macros or not.

I would probably suggest, under the WorkBook_Open() event to make excel hidden using the application.visible property and setting it to false. Don't forget to turn it back on once your splash form has finished or whenever an error has occurred.

Regarding fadeout, check out the following code example:


Hope this helps you out.

Cheers,

[royUK]

If it's tking up to 8 seconds to open, a Splash screen can only slow it further!

[JIBG]

Steven, Roy
Thanks for your suggestions; Roy I can not see the code, and I will try you tip on hidden the workbook until the splash screen closes. Roy I will keep the Splash Screen as simple as possible. Any ideas beside the old hardware why a workbook may take that long to open? Any setting, macros, etc that can cause the workbook to open this slowly?

[Steven_Daniel]

Hi JIBG

Sorry. I forgot to include the hyperlink containing the code for the Fade-In-Fade Out code for the userform splash screen.

Here it is below.

http://www.xcelfiles.com/SplashScrn.html

[JIBG]

That is exactly what I wanted, thanks Steve!

[Steven_Daniel]

Hi JIBG

Great! Thanks for the feedback. I am glad that it has fulfilled what you were looking for.

Cheers.