On open/closed events-and stuff

[Wandering Mage]

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.

 

[Tom Ogilvy]

see chip pearson's page on this

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

 

[Bob Phillips]

--

HTH

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

 

[Bob Phillips]

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)