Here is John Walkenbach's page on creating a Splash Screen:
http://j-walk.com/ss/excel/tips/tip39.htm

It uses a userform such as Colo suggests (didn't look at his file, so don't
know if the approaches are identical).

A msgbox is modal - so all activity halts until you respond to it. You
could put this up and say, click the button to continue, but the code is
halted until the user hits the button.

Jim Rech put up some code that calls a timed msgbox using one of the windows
scripting languages, but many people posted back that it didn't close for
them.

http://groups.google.com/groups?thre...%40tkmsftngp08

Sub SelfClosingMsgBox()
Dim wsh As Object
Set wsh = CreateObject("WScript.Shell")
wsh.Popup "Hello!", 2, "This closes itself in 2 seconds"
End Sub


--
Regards,
Tom Ogilvy

wrote in message
...
SO it is not possible to auto run the macro and receive a
prompt saying the marco is running?
-----Original Message-----
Hi wendy,

The macro will not start until [OK] button is clicked in
the message
box.
So I think using an userform is better in your case.
Please have a look @ attached sample file.

Attachment filename:
book1.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=401942
---
Message posted from http://www.ExcelForum.com/

.