Tom,

All macros are stored in workbooks, so you can simply copy the workbook file
to the other PC. Alternatively, you can export the module containing the
macro to a text file (with a "bas" file extension) and copy that file to the
other PC.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"tom" wrote in message
om...
hi
i am trying to copy a complicated macro to another pc ( primarily for safe
keeping)

any ideas?

Tom