Make Macro available to all new workbooks

[Guest]

I've got a macro that performs alot of tedious formatting processes. Each month, a new spreadsheet is downloaded from a "data warehouse" and replaces the previous spreadsheet (i.e. the one with the macro).

In the process of replacing the file, I lose the macro associated with it. How can I make a macro available to ALL spreadsheets?

 

[Frank Kabel]

Hi
put your macro in your personal.xls file or create an Addin

 

[Guest]

Can you expand on this? How do I access my personal.xls file?

 

[Frank Kabel]

Hi
see:
http://www.mvps.org/dmcritchie/excel/getstarted.htm