How do you indicate that one of your macros is an autoexec macro

[WantsToLearn]

Where do I go to designate a macro as being an autoexec macro (eg it runs immediately when the workbook file opens).

Thanks!

 

[LSTAN]

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 Autpen()
'
'Code to execute when workbook is
'open
'
End Sub

LSTAN

 

[SBendBuckeye]

Duh! Thanks, LStan! I had a brain cramp.

Have a great weekend!