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?