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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Multiple workbook sheets into one workbook 0
Macro to list report results 3
Macro for hiding zero data rows while printing 1
email from worksheet 2
sharing macros with other users 3
Excel Macro (open and save files with different drives) 1
macro to print xps then save with name value in (B2) 8
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1

Back
Top