How to copy VB macro from one spreadsheet to another?

  • Thread starter Thread starter Paul
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Active X VB no longer works in Excel 2008 home & student? 1
Inserting cells (shift cells right) using macro 0
Tranfering data from one spreadsheet to another Automatically 2
Copy Columns based on Header name 1
Excel macro help needed to copy columns from one open excel toanother open excel, and shall run on a 5
Still getting Macro Security Warning Message after removing Macro 3
How to pause a macro to allow user to select cell 2
VB Excel Macro 5

Back
Top