Sure is. One of two ways
Add an event procedure called Workbook_Open to the This workbook code module
Private Sub Workbook_Open()
... do your stuff
End Sub
or simply add a procedure called Auto_Open in a general code module
Sub Auto_Open()
... do your stuff
End Sub
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Darin Kramer" wrote in message
...
Hi there, I want a Macro to run automatically when a workbook is opened
- is it possible..?
Thanks
D
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!