How can I get my macro to appear in ALL worksheets

  • Thread starter Thread starter Roger Ottaway
  • Start date Start date
R

Roger Ottaway

I have a macro that I want to be available in ALL workbooks/worksheets when
opened, even those worksheets emailed to me. Is there a excel.xlt standard
template in excel2002 the same as a normal.dot templace in WORD ?

How can I do this ?

thanks .. Roger
 
Thanks, how can I find PERSONAL.xls, can I open it and store my macro in it?

thanks .. Roger
 
Roger,
If you do not see in the VBA IDE, then in Excel go to Window>UnHide.. and
select it.

Then whenever you open Excel, code in it will be available to you.

NickHK
 
Hi Roger,

As Nick says you need to put your code into your personal.xls file. This
file may not be available in which case you create a file by that name (Open
an new work sheet > Click file > Save as) If you are using windows XP / 2000
you should save the file to C:\Documents and Settings\*Your
Username*\Application Data\Microsoft\Excel\XLSTART (Any file place in this
folder will start when excel starts). If Win9x / NT save to C:\Program
Files\Microsoft Office\OFFICE\XLSTART

Regards

Paul
 
Back
Top