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

  • Thread starter Save a macro in Excel
  • Start date
S

Save a macro in Excel

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?
 
G

Gary''s Student

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