Fix an Excel VBA Macro That Will Not Run on Mac
Question details
Run an Excel VBA macro on a Mac when its workbook works on Windows but the macro appears unavailable or disabled.

- 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.
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.
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.
In Excel for Mac, open the workbook and select Tools > Macro > Visual Basic Editor.
In the Project Explorer, expand the workbook's VBA project and its Modules folder. Select the module whose name contains an accented character.
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.
Return to the worksheet, Control-click or right-click the macro button, and select Assign Macro. Choose the intended macro and click OK.
Select File > Save to keep the workbook in the .xlsm format, then click the button to test the macro on the Mac.

Check Excel for Mac macro security settings
Check macro permissions if the renamed module and reassigned button still report that macros are disabled.
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.

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.




