Running a macro when a Wb is opened

  • Thread starter Thread starter Marco Rodas
  • Start date Start date
M

Marco Rodas

What are the exact steps I need to take in order to get a
macro to start when a workbook is opened? I am using
Excel 2000.

Thank you in advance.

Marco
 
Marco,

There are two ways. One is to name the macro Auto_Open. The
other is the use the Workbook_Open event procedure in the
ThisWorkbook code module.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Right click on the excel logo in the upper left of your screen next to
FILE>view code>select workbook>insert your macro
 
Back
Top