Macros are stored in workbooks, so copy the workbooks across. By
default, XL stores recorded macros in the personal.xls workbook, which
is stored in your XLStart directory.

Macros may also be stored in Add-ins - either XL/VBA or DLL. Copy those
as well.

In article ,
"brodine" wrote:

I am migrating to a new computer. Is there a way to copy an Excel macro from
my old computer to my new machine?