Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add-in to run macro when ANY workbook is opened? | Excel Programming | |||
Looking for a way to run a macro when the workbook is opened | Excel Programming | |||
Running a macro when a Wb is opened | Excel Programming | |||
Run a macro when a workbook is opened | Excel Programming | |||
Run a macro when a workbook is opened | Excel Programming |