How do I save macro so it's there for all Excel sheets?
 

We export and print different reports each day, and I want the same macro to
run for each daily report. But when I open a new report (saved in the same
folder as the other reports) the macro is gone. How do I get the macro to
show up on each Excel report?

Put it in your personal.xls file.
http://www.vbaexpress.com/forum/arti...ticle&artid=18
************
Anne Troy
www.OfficeArticles.com

"Save a macro in Excel" <Save a macro in
wrote in message ...
We export and print different reports each day, and I want the same macro
to
run for each daily report. But when I open a new report (saved in the
same
folder as the other reports) the macro is gone. How do I get the macro to
show up on each Excel report?

If the use the macro a lot, then save the workbook containing the macro as
personal.xls in your XLSTART folder. Anytime you start Excel, the macro will
be available.
--
Gary''s Student


"Save a macro in Excel" wrote:

We export and print different reports each day, and I want the same macro to
run for each daily report. But when I open a new report (saved in the same
folder as the other reports) the macro is gone. How do I get the macro to
show up on each Excel report?