WorkbookOpen Event
In the top left hand corner of the Excel Window there is a green excel icon.
Right click on that Icon and select View Code. This is a short cut to get
into the ThisWorkbook Object...
HTH
"JJ" wrote:
I am trying to run code as soon as a workbook is opened. I have researched
how to do this, however many people comment on using code in ThisWorkBook,
which is suppose to be between Microsoft Excel Objects and Modules in the
project explorer. It is not showing there...what am I doing wrong?
|