Forum Discussion
Solved
Run macro on startup
I have written a macro I ant to run when the spreadsheet it is in is launched. I have followed the instructions exactly in Help, yet the macro does not run. Has anyone experienced this issue and i...
- I thought lthat may have been the problem, but I didn't test it. Thanks.
Thanks! You should not have renamed Workbook_Open to Startup. Change
Private Sub Startup()
back to
Private Sub Workbook_Open()
Save and close the workbook, then reopen it. The code should now run.
I thought lthat may have been the problem, but I didn't test it. Thanks.