How can I transfer my Excel VBA macro modules to a new Mac?

Dear @Seoul Park,

Based on your description, you wonder would it be possible to transfer VBA macro modules from one Mac computer to another without recreating them manually.

You can transfer VBA macro modules between Mac computers without recreating them.

Try export and import the VBA Module

On your source Mac:

1. Open the workbook that contains the macro.
2. Open the Visual Basic Editor.
3. Right-click the module under Modules and select Export File.
4. Save the module as a.bas file

Transfer the .bas file to the other Mac using AirDrop, USB drive, email, or another file-sharing method.

On the destination Mac:

1. Open the target workbook.
2. Open the Visual Basic Editor.
3. Right-click the workbook or Modules folder and select Import File.
4. Browse to the exported .bas file and import it.

Alternative Option

If the macros are stored within a specific workbook, you can simply copy the macro-enabled workbook (.xlsm) to the other Mac. The macros will be included in the workbook.

For reference

Copy a macro module to another workbook

Import and shape data in Excel for Mac (Power Query)

I hope information above meet your expectation, if you have any other questions, please feel free to reach out.

If the answer is helpful, please click "Yes" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.