Microsoft Excel – Copying VBA Module from one workbook to another.
John B has a workbook with a lot of data.
He created a new workbook with a macro for testing. Now that the macro is working, he wants to copy the working macro from the test workbook to the workbook with all of his data.
This video shows how to launch the VBA Editor with Alt+F11
Display the Project Explorer.
Drag the module from one workbook to another.

Remember to Save As the workbook as XLSB or XLSM. If you save the workbook as XLSX, your macros will be removed.

Topics:
How to copy Excel VBA?

How To Copy A Macro From One Excel To Another
How To Copy A Macro From One Excel Workbook To Another
How To Copy A Macro In Excel

How To copy macros Excel?
How Do I Copy A Macro Fromone Excelfile To Another?