WorkbookOpen Event
 

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?

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?

WorkbookOpen Event
 

Jim's shortcut is the quickest way -and I never knew about it!
If you're in the IDE, look in the Project Explorer and for your workbook
look in Microsoft Excel Objects. You will see ThisWorkbook there.

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