Export the macro to a .Bas file from the VBE. Import it into the new
workbook

To do either, go to the project explorer and right click on the module name
or the Modules entry.

--
Regards,
Tom Ogilvy



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

any ideas?

Tom