How to get a macro to execute for every xls thats opened on a mach

[Guest]

I've got a macro that executes when the spreadsheet is opened. Is there a
way to set this marco to execute for any spreadsheet that is opened on my
machine? Not just the one that has the macro embeddid in it?

 

[Guest]

You need to get your head around applicaiton level wvents. Take a look at
this link to get started...

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

 

[Nick Hodge]

Put the code in your personal.xls workbook

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)