How to copy VB macro from one spreadsheet to another?

P

protonLeah

One way is to open both wb's at the same time; select "show code", find
the sheet or module in the source wb that contains the macro, highlight
the code and copy. Select the desired sheet or module in the target wb
and paste...

:cool: Ben
 
Top