We help IT Professionals succeed at work.

How can I import macros from another workbook into a new workbook?

How can I import all macros from one workbook to another?
Comment
Watch Question

In the vba Project window - right click the selected sheet you wish to copy over - select Export file... In the new workbook - in the vba Project window - right click the vba Project window - select Import file... select location where the exported file was saved - you should be good to.

Note: doing this across different versions of software may not work correctly.