-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel autoexec macro
- Thread starter cto
- Start date
Juan Pablo González
MrExcel MVP
- Joined
- Feb 8, 2002
- Messages
- 11,959
Do you mean excecute a macro each time ANY file is opened or one SPECIFIC file is opened ?
Upvote
0
Juan Pablo González
MrExcel MVP
- Joined
- Feb 8, 2002
- Messages
- 11,959
Then, do this:
Open the workbook.
Right click on the little workbook icon next to the "File" menu and choose "View Code"
Select, from the first dropdown, "Workbook" and from the second one "Open".
Between these two lines
Private Sub Workbook_Open()
End Sub
You can put the macro you want to execute.
Open the workbook.
Right click on the little workbook icon next to the "File" menu and choose "View Code"
Select, from the first dropdown, "Workbook" and from the second one "Open".
Between these two lines
Private Sub Workbook_Open()
End Sub
You can put the macro you want to execute.
Upvote
0
pen if you want it to execute when you open it. If you want it to execute when you close the file (such as to autmatically save changes) call it Auto_Close.Similar threads
- Question
