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

How can I import all macros from one workbook to another?
Who is Participating?
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.