Self-running macros in Excel
As above. ian mcgregor
Use the workbook activate eventIn the code for ThisWorkbook, put:
Private Sub Workbook_Activate()Blah blah End Sub