Running a macro when a Wb is opened

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
 
C

Chip Pearson

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
 
D

Don Guillett

Right click on the excel logo in the upper left of your screen next to
FILE>view code>select workbook>insert your macro
 
Top