auto execute

J

jpepper

I have a macro that I want to run automatically when the
user opens up the workbook and select enable macro. Does
anybody know how i can do that.

Thanks in Advance
 
G

Gabor G

Sub Auto_Open()
'WriteYourCodeHere
End Sub

You give the above name to your macro and it will run upon opening the
workbook.
Gabor
 
S

Sean

Go into VBA, Expand "VBAProject (Book1)" tree and you should see a folder
called "Microsoft Excel Objects". Under that you should see "ThisWorkbook".
Double click "ThisWorkbook" to get the code window. In the left drop-down
above the code window, select workbook. The code:
Private Sub Workbook_Open()

End Sub
....should be put in automatically. Now insert the name of the sub that
starts your macro within this new sub.

When you launch XL it should automatically run your macro.

--
______________________________
Thank you, Sean
Artist/Production Manager
Please visit us at www.oatesflag.com
502-267-8200
502-267-8246 fax
 
Top