K k483 Jun 19, 2004 #1 How do you execute a Macro on loading a worksheet (that is, withou having to click a button or cell)
C Chip Pearson Jun 19, 2004 #2 If you name the macro Auto_Open, it will execute when the workbook is opened. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
If you name the macro Auto_Open, it will execute when the workbook is opened. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
G Gord Dibben Jun 19, 2004 #3 Worksheet or Workbook? Sheet Module... Private Sub Worksheet_Activate() 'your macro name or code End Sub ThisWorkbook Module.... Private Sub Workbook_Open() 'macro name or code End Sub Gord Dibben Excel MVP
Worksheet or Workbook? Sheet Module... Private Sub Worksheet_Activate() 'your macro name or code End Sub ThisWorkbook Module.... Private Sub Workbook_Open() 'macro name or code End Sub Gord Dibben Excel MVP
