see chip pearson's page on this

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"Wandering Mage" wrote in message
...
First, could anyone tell me how to script on open/closed
events, where they go and how you get them there and the
like. I've never been able to find out how to script
module stuff. I thought I read somewhere once that I was
suppose to right click on the workbook and go to view
code, kind of like you do for a sheet. That never works
for me, no view code option ever comes up.

Also, will a variable stay true into another macro when
you execute one macro from another?

Thanks for the help.