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.

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.

--

HTH

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

"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.

If you don't have the worksheet maximized -
At the top-left of a worksheet there is an Excel icon, right-click this and
select View Code. This will take you into the ThisWorkbook code module.

If it is maximized -
The Excel icon moves to the left of the File menu in the Excel window.

Once in the ThisWorkbook window, click on the Object drop-down at the
top-left to select the Workbook object. In the Procedure drop-down, right of
the Object drop-down, and you will see the events available to the Workbook
object.

--

HTH

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

"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.