J Joseph Oct 19, 2003 #1 I would like to know how to have an Excel worksheet automatically execute a macro on startup?
J John Wilson Oct 19, 2003 #2 Joseph, The easy way is to use the Auto_Open macro. Sub Auto_Open() ' your macro here End Sub Another way would be to use the Workbook_Open Event handler. John
Joseph, The easy way is to use the Auto_Open macro. Sub Auto_Open() ' your macro here End Sub Another way would be to use the Workbook_Open Event handler. John
D Dave Peterson Oct 19, 2003 #3 You can put your code in a general module and name that macro auto_open. (You could also put the code in the workbook_open event under the ThisWorkbook module.) Then when you open your workbook (with macros enabled), your code will run.
You can put your code in a general module and name that macro auto_open. (You could also put the code in the workbook_open event under the ThisWorkbook module.) Then when you open your workbook (with macros enabled), your code will run.
