-
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.
enable macros automatically
- Thread starter hmk
- Start date
Greg Truby
MrExcel MVP
- Joined
- Jun 19, 2002
- Messages
- 10,025
To have a macro execute automatically, put it in the Workbook's Open method.
No, you cannot programmitically defeat safety measures (think about it...:wink
No, you cannot programmitically defeat safety measures (think about it...:wink
Upvote
0
lynnnow
Active Member
- Joined
- Aug 6, 2004
- Messages
- 278
hi,
you can do this by right clicking on the Sheet1 tab and click on View Code.
here put the following code:
Private Sub Workbook_Open()
Call YourStartupCode
End Sub
this will run the code you want to start when you open the excel file. Replace YourStartupCode with the procedure name you want to start with.
you can do this by right clicking on the Sheet1 tab and click on View Code.
here put the following code:
Private Sub Workbook_Open()
Call YourStartupCode
End Sub
this will run the code you want to start when you open the excel file. Replace YourStartupCode with the procedure name you want to start with.
Upvote
0
Greg Truby
MrExcel MVP
- Joined
- Jun 19, 2002
- Messages
- 10,025
To add to what Smitty recommended, you might add the term xlveryhidden to your search criteria. "Forcing" macros to be enabled almost always entails the use of that property.
Upvote
0
