WantsToLearn
Programmer
Where do I go to designate a macro as being an autoexec macro (eg it runs immediately when the workbook file opens).
Thanks!
Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do you indicate that one of your macros is an autoexec macro
- Thread starter WantsToLearn
- Start date
- Status
Hi
Do it at the ThisWorkBook module. Choose the Workbook_Open() procedure.
eg:
Private Sub Workbook_Open()
'
'Code to execute when workbook is
'open
'
End Sub
Alternate you can insert a blank module and have the Auto_open() procedure in it.
eg:
Sub Aut
pen()
'
'Code to execute when workbook is
'open
'
End Sub
LSTAN
Do it at the ThisWorkBook module. Choose the Workbook_Open() procedure.
eg:
Private Sub Workbook_Open()
'
'Code to execute when workbook is
'open
'
End Sub
Alternate you can insert a blank module and have the Auto_open() procedure in it.
eg:
Sub Aut
pen()'
'Code to execute when workbook is
'open
'
End Sub
LSTAN
SBendBuckeye
Programmer
Duh! Thanks, LStan! I had a brain cramp.
Have a great weekend!
Have a great weekend!
- Status
Similar threads
- Locked
- Solved
- Locked
- Helpful tip
- Locked
- Question