How can i move a macro from one computer to another

[TorToms]

i would like to move a macro from one computer to another i Excel

 

[Dave Peterson]

Macros live in excel workbooks.

So you can just copy that workbook with the macro to the other pc and open it
there.

 

[Gord Dibben]

Or you could export the module containing the macro as a *.BAS file, email it
to other computer then import to another workbook.

Gord Dibben Excel MVP

 

[Dave Peterson]

I'm not sure I'd trust the average excel user to know what to do with this,
though.

But if there were only one routine that needed to be shared, I'd use a variation
of Gord's suggestion.

I'd just copy that code into a new workbook's project. Then save that
workbook. Then send it off.