On Open Macro

T

Tom

When I open a particuliar workbook I would like to run a master macro
automatically. How can I make this happen?
TFTH,
Tom
 
C

Chip Pearson

Name the macro Auto_Open and it will execute when the workbook is
opened.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
C

Chip Smith

you could also set another private sub that will look like this..

Private Sub Workbook_Open()

enter macro name here

End Sub
 
Top