Luke M Excel Ninja Staff member Feb 9, 2012 #2 In the VBE, go to the ThiwWorkbook module, and use this: [pre] Code: Private Sub Workbook_Open() 'Do something here Call MyMacro End Sub [/pre]
In the VBE, go to the ThiwWorkbook module, and use this: [pre] Code: Private Sub Workbook_Open() 'Do something here Call MyMacro End Sub [/pre]