macro to run automatically

[JRS]

How do I get a macro to run upon startup of my workbook/worksheet?

 

[VoG]

Try like this in the ThisWorkbook module

Private Sub Workbook_Open()
Call MyMacro
End Sub

 

[rs2k]

Use the workbook open module.