So how is this different from saving the workbook with the macro as a .xla
file and then using Tools AddIns to add it to the workbooks in which it
needs to run?

"dq" wrote:

You can do this either manually or put it in the Workbook_Open event.
(in the ThisWorkbook codepane)

DQ