There are 2 workbook events.

Workbook_Open

and

Workbook_BeforeClose that you can use.

Check help.


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Rich Cooper" wrote in message
...
I am trying to get a event to run upon the opening of excel and also want
an
event to run as the user closes excel. Any help would be greatly
appreciated.

Thanks