G Guest Apr 1, 2006 #1 When I open a particuliar workbook I would like to run a master macro automatically. How can I make this happen? TFTH, 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 Apr 1, 2006 #2 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
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
G Guest Apr 1, 2006 #3 you could also set another private sub that will look like this.. Private Sub Workbook_Open() enter macro name here End Sub
you could also set another private sub that will look like this.. Private Sub Workbook_Open() enter macro name here End Sub