There are a bunch of events. They are accessed from two places. One is the
worksheets and the other is the "ThisWorkbook" object. In the
VB window just
above the code window you will see two drop downs. The one on the left says
General. Change it to Worksheet or ... and a code procedure will be
automatically entered into the code window for you (delete it if it is not
the one you want). The drop down to the right lists all of the events for
that object (Sheet, ThisWorkbook, embeded controls...).
Modules do not have events. Forms can have events but it sounds like you are
familiar with this concept. Classes can have events but that is a little more
explanation than I am prepared to get into...
--
HTH...
Jim Thomlinson
"BFarrell" wrote:
Are there similar EVENTs in Excel operating on the Workbook or Sheets, as
there are in Access that will execute against FORMS, i.e. 'On Open', 'On
Activate'.
I want to execute some code when certain sheets are accessed in my workbook.
Thanks!