Create a splash screen in excel

[Guest]

How do I create splash screen that will open with the excel file and display
my name etc.

 

[Norman Jones]

Hi Cash,

See xlDynamic's SplashScreen code and example at:

http://www.xldynamic.com/source/xld.xlFAQ0007.html

 

[Guest]

Thank you Norman

I still have a problem with this example.
When I open my Excel workbook, the splash screen just hangs there until I
close it

 

[Harald Staff]

One code goes into a statdard module. Did you by accident put it in the
userform module or somewhere else ?

HTH. best wishes Harald

 

[Guest]

Many thanks for the response Harold.

I have sorted the problem. As you suggested, I had not created a public sub
procedure in the general modul