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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel is removing Macros from workbook 3
Getting the name & path of a hidden WB 2
closing another file by code causes failure to run workbook activate event 2
Implement a progress bar when the macro run inside another workboo 2
Macros disabled, not by security settings? 5
Addin - Look for a File when it is opened 1
How to Unlock Excel Workbook protected by MACRO Password 6
access data from a closed wb protected with password without openi 6

Back
Top