Macro Recorder for Mac Excel: Setup, Steps, and Limits

VBA & macros · Updated November 21, 2026

Yes. Excel for Microsoft 365 for Mac has a macro recorder: enable the Developer tab if it is hidden, choose Developer > Record Macro, perform the actions you want to automate, and select Developer > Stop Recording. The recorder turns supported actions into VBA code, which you can run again from the workbook.

What the macro recorder does

A macro is a saved sequence of instructions for Excel. The recorder observes many of the actions you perform—such as selecting cells, entering values, applying number formats, and changing column widths—and writes corresponding Visual Basic for Applications (VBA) statements. You do not need to know VBA to make a basic recording, although understanding the generated code helps when you need to fix or extend it.

For example, suppose you receive a monthly report with dates in column A and amounts in column B. You could record a routine that bolds the header row, formats the amounts as currency, adjusts the columns, and applies a filter. The next time you receive a report with the same layout, you can run the macro instead of repeating those steps by hand.

The recorder is best for repetitive, predictable tasks. It is not a general-purpose observer that can infer your intentions: if you click a particular cell, it records an instruction for that cell or selection, not a flexible rule such as find the last row and format every entry. Some tasks also cannot be recorded or may produce awkward code.

Make the Developer tab available on a Mac

The Developer tab contains the recording controls and access to the VBA editor. In current Excel for Mac, open Excel > Settings > Ribbon & Toolbar, select Main Tabs, and turn on Developer. In older releases the menu may be called Excel > Preferences rather than Excel > Settings. The Developer tab should then appear in the ribbon.

If you do not see the same wording, confirm that you are using the desktop Excel app. Excel for the web does not provide the VBA macro recorder, even if a workbook containing macros can be opened there. Menu labels can also vary slightly between Excel releases, but enabling the Developer main tab is the relevant setting.

Record a macro step by step

  1. Open the workbook you want to automate. If you are experimenting with an important file, save a separate copy first.
  2. Choose Developer > Record Macro. In the dialog, enter a descriptive name. Macro names cannot contain spaces; use a name such as FormatMonthlyReport.
  3. Choose where to store the macro. This Workbook keeps it with the open file; New Workbook places it in a new workbook; Personal Macro Workbook makes it available in Excel on that Mac.
  4. Optionally add a description, then start recording. From this point, Excel records supported actions, so avoid unrelated clicks or edits.
  5. Carry out the task in a clear, repeatable order. For example, select the header row, apply bold formatting, select the amount column, set its number format, and adjust the column width.
  6. Choose Developer > Stop Recording as soon as the intended task is complete. Do not just close the workbook and assume the recording will stop cleanly.

The Record Macro dialog may offer a shortcut field. If you assign a shortcut, choose one that will not conflict with a shortcut you use regularly. A shortcut is optional; you can always run the macro through the Macros command instead.

Absolute and relative references

One important setting determines whether recorded cell actions target fixed addresses or follow your starting position. With absolute references, a recording that formats cells A1:B20 will generally refer to those same cells each time. This can be suitable when the report always occupies the same range, but it can fail when the data grows or starts elsewhere.

With relative references, actions are recorded in relation to the active cell. For example, if you begin on a data row and record moving one cell right before applying a format, the instruction can apply relative to the cell selected when the macro runs. In Excel for Mac, use Developer > Use Relative References before recording when that control is available. It is a toggle, so check its state before you start rather than assuming the previous recording left it set the way you want.

Relative references do not automatically make a macro adapt to any table size. A recorded selection that moves down a fixed number of rows is still fixed in size. If the number of records changes regularly, you may need to edit the VBA or use a table-based approach rather than rely on a literal recorded range.

Run, inspect, and edit the recording

To run a macro in desktop Excel for Mac, choose Developer > Macros, select its name, and choose Run. You can also use the Macros command from the View tab in releases where it is shown there. Check the workbook after the first run: a macro repeats its recorded actions, including unintended actions that were accidentally captured.

To inspect or adjust the generated code, open Developer > Visual Basic. The Visual Basic Editor shows the macro in a module, where you can review the statements and make changes. For example, a recorder may have captured an exact range such as A1:B20. If future reports have a different number of rows, changing the code to find the data boundary takes VBA knowledge beyond basic recording.

Macros are not undone with Command+Z on a Mac or Ctrl+Z on Windows. If a macro changes or clears data, undo is generally not available after it runs. Save a copy of the workbook before running an unfamiliar macro, and test it on sample data first. This is especially important for recorded steps involving deletion, replacement, sorting, or pasting over existing content.

Save and share a macro-enabled workbook

To keep a VBA macro in the workbook, save it in a macro-enabled Excel format, usually Excel Macro-Enabled Workbook (.xlsm). If you save a workbook containing VBA as a standard .xlsx file, Excel warns that the macros cannot be retained in that format. Choose the macro-enabled format if you need the code to remain with the file.

The storage choice matters when sharing. A macro saved in This Workbook travels with that workbook when the .xlsm file is shared, although recipients still need desktop Excel with macros permitted to run it. A macro in the Personal Macro Workbook is intended for your own Excel environment and is not automatically carried inside a report you send to another person. The recipient would need the macro separately or a copy stored in the shared workbook.

Excel for the web can open and edit many workbook contents, but it cannot create, run, or edit VBA macros. A recipient who needs to execute the recorded routine should use desktop Excel. On a Mac, VBA is supported, but code written for Windows can rely on Windows-only features, so test cross-platform workbooks on the actual systems that will use them.

Mac-specific compatibility and limitations

Excel for Mac supports VBA, but it is not identical to Excel for Windows. Windows-specific VBA calls, Windows API declarations, and some COM or ActiveX-based features do not work on a Mac. ActiveX controls are a notable platform difference. A simple formatting macro is usually a more portable starting point than one that depends on Windows components, external applications, or machine-specific file locations.

File paths are another common source of trouble. A macro that refers to a drive letter or a Windows folder path may not point to the equivalent location on macOS. If a macro accesses files, use a design that accounts for the Mac file system and test it on the intended Mac. Also check any add-ins or external connections the recorded actions depend on; the fact that a workbook opens does not guarantee every dependency is available.

The recorder captures actions, not a polished workflow. It may include extra selections, repeated formatting statements, or references that only make sense for the original layout. If the procedure must handle missing data, changing row counts, prompts, or errors, recorded code may need editing or replacing with a deliberately written macro.

Macro security and safe use

Macros can change workbook data and may perform other actions through VBA. Treat a macro-enabled file from an unknown sender as code, not merely as a spreadsheet. Excel may show a security warning or prevent macros from running according to the file and security settings. Only enable a macro when you trust the source and understand why it is needed; do not lower security protections just to open an unfamiliar file.

For a macro you create yourself, keep a clean backup and test on a duplicate containing representative data. Check the code and its stated purpose before sharing it, and tell recipients what the macro does. If a trusted work file is blocked, follow your organization’s approved process rather than changing security settings on your own. Security controls and available options can differ by Excel version and organizational policy.

When to use a recorder, VBA, or another tool

Use the recorder when the task consists of a short sequence of repeatable Excel commands and the input layout stays consistent. It is a practical way to learn which VBA statements correspond to familiar actions. Use hand-edited VBA when the workflow needs conditions, loops, dynamic ranges, error handling, or a choice of files. A recorded macro can be a useful draft, but it may require cleanup before it is dependable.

If the goal is collaboration or browser-based automation, consider whether Office Scripts is available in your Microsoft 365 environment. Office Scripts is a separate automation model, not VBA, and its availability depends on the account, platform, and organization settings. For a one-off task, built-in Excel features such as tables, filters, and cell styles may be simpler and safer than a macro. The right choice depends on whether the task is repeated, how variable the data is, and which Excel platforms must support it.

Frequently Asked Questions

Does Excel for Mac have a macro recorder?
Yes. Desktop Excel for Mac includes the recorder. Enable the Developer tab if needed, then choose Developer > Record Macro. Excel for the web does not record VBA macros.

Can I record a macro without knowing VBA?
Yes. You can record supported actions and run the result without writing code. However, basic VBA knowledge helps if the recorded cell references are too fixed or the task needs decisions that the recorder cannot capture.

Why is Record Macro missing on my Mac?
The Developer tab may be hidden. Open Excel > Settings (or Preferences in older releases) > Ribbon & Toolbar and enable Developer under Main Tabs. Also check that you are using the desktop app, not Excel in a browser.

Can a Mac-recorded macro run in Excel for Windows?
Often, a straightforward macro using standard workbook and formatting operations can, but compatibility is not guaranteed. Windows-only APIs, ActiveX, COM dependencies, and platform-specific file paths can prevent code from working across systems. Test the workbook on each platform it must support.

How do I save a macro so it stays in the file?
Save the workbook as an Excel Macro-Enabled Workbook (.xlsm). A standard .xlsx file cannot retain VBA macros. If the macro was stored in the Personal Macro Workbook, it is not automatically included with the workbook you share.

Related

Try it: the Column Letter to Number: aA is 27, XFD is 16,384. Converts both ways.

More in VBA & macros

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.