Macro's on startup

K

k483

How do you execute a Macro on loading a worksheet (that is, withou
having to click a button or cell)
 
C

Chip Pearson

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

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
 
Top