Splash Screen

[John Calder]

Hi

I run Excel 2K

Can anyone tell me how I can create a Splash Screen for when I open a
spreadsheet?



Thanks

John

 

[AltaEgo]

You need to design a form for your splash screen then use VBA to call and
close it.

The following should help.

Create a form
http://www.datapigtechnologies.com/flashfiles/exceluserform1.html

Splash screen
http://www.brainbell.com/tutorials/ms-office/excel/Create_A_Workbook_Splash_Screen.htm

 

[AltaEgo]

This takes more than a few steps. However, if you take it step-by-step and
pause the video between steps, you should be able to achieve very good
results.

http://www.datapigtechnologies.com/flashfiles/exceluserform1.html