Want macro to run in personal.xls upon starting Excel...
J J.E. McGimpsey Nov 14, 2003 #2 Put this in the ThisWorkbook code module of personal.xls: Private Sub Workbook_Open() MyMacro End Sub where MyMacro is the name of your macro which is stored in a regular code module in personal.xls.
Put this in the ThisWorkbook code module of personal.xls: Private Sub Workbook_Open() MyMacro End Sub where MyMacro is the name of your macro which is stored in a regular code module in personal.xls.
