ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Splash Screen (https://www.excelbanter.com/new-users-excel/230410-splash-screen.html)

John Calder

Splash Screen
 
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

Splash Screen
 
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/f...userform1.html

Splash screen
http://www.brainbell.com/tutorials/m...ash_Screen.htm

--
Steve

"John Calder" wrote in message
...
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

Splash Screen
 
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/f...userform1.html


--
Steve

"John Calder" wrote in message
...
Hi

I run Excel 2K

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



Thanks

John




All times are GMT +1. The time now is 11:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com