Making a Macro Run Automatically

[ElsiePOA]

My mind has gone blank. I have a Macro which I want to have ru
automatically every time I open any Workbook, but I have forgotten ho
to make it do that.

*HELP!

 

[Don Guillett]

Please post in ONLY one group. See answer in other post.

 

[Ron de Bruin]

Hi Elsie

Sub Auto_open()
MsgBox "Hi"
End Sub

Must be in a normal module
If you use a Auto_open macro then this wil not run if you open the file with a macro

Or a event

Private Sub Workbook_Open()
'macro name or code
End Sub

Right click on the Excel icon next to File in the menubar
And choose View code

You are now in the Thisworkbook module
Paste the Event in this place
Alt-Q to go back to Excel
Save and close the file

Read Chip Pearson's site about Events
http://www.cpearson.com/excel/events.htm

 

[ElsiePOA]

Thanks Ron

What I was really wondering however is whether you can cause a macro t
run automatically whenever you open *ANY* workbook, or is it necessar
to do the Workbook-Open procedure individaully in each workbook

 

[Dave Peterson]

There are things called application events.

If you want to read more about them, visit Chip Pearson's site:
http://www.cpearson.com/excel/AppEvent.htm

(don't forget to get the sample workbook at the bottom of that URL)