Running of a Macro when Workbook is opened
 

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!

Running of a Macro when Workbook is opened
 

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!

Running of a Macro when Workbook is opened
 

This can be done with the Workbook_Open event.

See Chip Pearson's page that explains workbook related events

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"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!