E Edgar Nov 10, 2003 #1 Hi I was wondering how automatically run a macro everytime i open a workbook. Thanks
T Ture Magnusson Nov 10, 2003 #2 Edgar, 1. In the Project Explorer window, double-click "ThisWorkbook" 2. Create a Workbook_Open procedure, something similar to this: Private Sub Workbook_Open() MsgBox "Hello there!" End Sub 3. Save the workbook. Ture Magnusson Karlstad, Sweden
Edgar, 1. In the Project Explorer window, double-click "ThisWorkbook" 2. Create a Workbook_Open procedure, something similar to this: Private Sub Workbook_Open() MsgBox "Hello there!" End Sub 3. Save the workbook. Ture Magnusson Karlstad, Sweden
