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.