Saving Macro

[RSteph]

I've made a macro for an Excel file. The macro is designed for formatting and
restructuring a sheet that is read in from a file created by another program.
It goes through and formats cell, rows, and columns as needed, as well as
alters data where needed.

I'd like to save this macro so that I can use it on other sheets. As every
time I have to run the report to make the file, then open it in Excel, I'll
be opening it in a new instance of Excel. How can I go about saving this, so
that anytime I open Excel that Macro is available to the current workbook?

 

[Nigel]

The simplest thing to do would be to save it in your personal macro
workbook.

If you have not created one already, then record a new macro and chose the
drop down store in 'Personal Macro Workbook'

A new workbook is created (default called Personal.xls), in the autoopen
directory of Excel, when you open Excel this workbook is also opened yet it
is hidden. Macros in the workbook can be run from the visible workbook.