How do I copy a VB macro from one spreadsheet to another.
P protonLeah Apr 11, 2006 #2 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... Ben
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... Ben