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

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

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