Search this group for 'Splash Screen' and you will get lots of hits on how to
do this or go he-

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

Mike

"adesh" wrote:

I am keen in having a pop up window display on opening an excel file, which
summarizes the contents. This window can be closed by clicking mouse anywhere
on the window itself. I know how to apply this concept in MS Access but not
in Excel. Can anyone please suggest a solution to this. With many thanks and
regards,

adesh