VBA & Macro Problems

Fix an Excel VBA Macro That Will Not Run on Mac

Natalie TaylorNatalie Taylor Nov 22, 2026 868 views

Question details

Run an Excel VBA macro on a Mac when its workbook works on Windows but the macro appears unavailable or disabled.

Fix an Excel VBA Macro That Will Not Run on Mac
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
A user opens a macro-enabled workbook created or used on Windows and tries to run a macro from a button on a Mac.
Observed behavior
Excel reports that the macro is unavailable or disabled, and the VBA project contains a module name with an accented character.
Before you start

Open the macro-enabled workbook in Excel for Mac and identify the button and macro you want to run. Confirm that the workbook is from a trusted source before enabling any macros.

Solution 1Recommended

Rename the VBA module and reassign the macro button

Use this fix when a VBA module name contains an accented character and the macro works on Windows but not on Mac.

1
Open the VBA editor

In Excel for Mac, open the workbook and select Tools > Macro > Visual Basic Editor.

2
Find the module

In the Project Explorer, expand the workbook's VBA project and its Modules folder. Select the module whose name contains an accented character.

3
Rename the module

Select View > Properties Window in the VBA editor, then change the module's Name property to an ASCII-only name such as Module1 or Modulo1.

4
Reassign the button

Return to the worksheet, Control-click or right-click the macro button, and select Assign Macro. Choose the intended macro and click OK.

5
Save and test

Select File > Save to keep the workbook in the .xlsm format, then click the button to test the macro on the Mac.

Rename the VBA module and reassign the macro button
Use compatible VBA names: Avoid accented and other non-ASCII characters in VBA module and object names to improve compatibility between Mac and Windows.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface and support for common Microsoft Office formats, making it easy to move everyday spreadsheet work. It does not fix Excel for Mac's VBA settings or guarantee that Excel macros will run.

Open and edit spreadsheets in a familiar interfaceCompatible with common Excel formats, including .xlsxReview workbook data without relying on a macro buttonUse a free, lightweight alternative for everyday Office tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel macro work on Windows but not on Mac?

An accented character in a VBA module name can cause a cross-platform naming issue. In the Visual Basic Editor, rename the module with ASCII characters and reassign the worksheet button.

How do I change a VBA module name on a Mac?

Open Tools > Macro > Visual Basic Editor, select the module in Project Explorer, and use View > Properties Window to change its Name property.

Why does the button still say the macro is unavailable after I rename the module?

The button may still point to the old macro reference. Control-click or right-click the button, choose Assign Macro, and select the intended macro again.

Where can I check whether Excel macros are disabled on Mac?

Open Excel > Preferences or Settings > Security & Privacy and review the macro security options. Enable macros only for files you trust.

Can an ActiveX button run my macro in Excel for Mac?

Excel for Mac does not support ActiveX controls. Try running the macro from Tools > Macro > Macros or replace the control with a compatible button.