Exporting a macro

[ReportsTeam]

I have 2 workbooks open and need to export a macro from 1 workbook to another and assign the macro to a shape...any ideas?

thanks in advance.
Kerry

 

[royUK]

Right click on your module in the VB editor and choose the Export option. Then select your other workbook and use the Import option.
To assign the macro to a shape simply right click on the shape and choosr assign macro and select your macro from the list

 

[ReportsTeam]

sorry, i didn't make it clear that i want to do this from a macro...