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

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?

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

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
--
HTH...

Jim Thomlinson


"john conwell" wrote:

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?

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

Put the code in your personal.xls workbook

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"john conwell" wrote in message
...
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?