Office for Mac Issues

Fix a Read-Only Macro-Enabled Workbook in Excel for Mac

Maira MehtabMaira Mehtab Nov 13, 2026 868 views

Question details

Determine why a macro-enabled workbook opens as read-only or produces an error when content is enabled in Excel for Mac.

Fix a Read-Only Macro-Enabled Workbook in Excel for Mac
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
A user opens an XLSM workbook that works on Windows and attempts to enable its content on a Mac.
Observed behavior
The workbook opens as read-only or displays an error when content is enabled.
Before you start

Confirm that the workbook is from a trusted source before enabling macros. If possible, ask its author whether it contains ActiveX controls or Windows-specific VBA code.

Solution 1Recommended

Check the Workbook for Read-Only Restrictions and ActiveX Controls

Identify whether file permissions, workbook protection, or unsupported controls could explain the behavior.

1
Check file permissions

In Finder, select the workbook and choose File > Get Info. Check whether Locked is selected and review Sharing & Permissions for your account.

2
Review workbook protection

Open the workbook in Excel and check the Review tab for sheet or workbook protection. If protection is preventing your intended changes, ask the author for permission or the password.

3
Show the Developer tab

In Excel, open Settings or Preferences > Ribbon & Toolbar, select Developer, and save the change.

4
Inspect the macros and controls

On the Developer tab, open Visual Basic or Macros to inspect the workbook. If you cannot identify the controls on the Mac, ask the author to check the workbook in Excel for Windows.

Check the Workbook for Read-Only Restrictions and ActiveX Controls
ActiveX compatibility: Excel for Mac does not support ActiveX controls. Their presence does not by itself prove why a workbook is read-only; permissions, protection, and other issues can also be responsible.
Free Microsoft Office alternative

Work with Spreadsheets Using WPS Office for Mac

WPS Office is a free, lightweight alternative with a familiar interface for everyday spreadsheet work. It supports common Microsoft Office formats, making it easier to move existing files, although it does not fix Excel for Mac's ActiveX limitations.

Open and edit everyday spreadsheets in a familiar interfaceCompatible with common Excel formats, including XLSX and XLSMove existing Office files into a lightweight productivity suiteUse a free alternative for spreadsheet tasks that do not depend on ActiveX controls
microsoft office alternative - wps office

Frequently Asked Questions

Can Excel for Mac run ActiveX controls?

No. ActiveX controls are not supported in Excel for Mac. Open the workbook in Excel for Windows or replace the controls with suitable Form Controls and test the revised workbook.

Does a read-only workbook always mean it contains ActiveX controls?

No. In Finder, use File > Get Info to check whether the file is locked and whether your account has write permission. Also check the Review tab in Excel for protection.

Can Excel for the web run the workbook's macros?

No. You can try opening the XLSM file from OneDrive for viewing or basic editing, but Excel for the web does not run VBA macros.

Do all UserForms fail in Excel for Mac?

Not necessarily. UserForm compatibility depends on the controls and VBA code used. Test the form in Excel for Mac and revise any Windows-specific features.

How do I display the Developer tab in Excel for Mac?

Open Excel > Settings or Preferences > Ribbon & Toolbar, select Developer, and save the change. You can then access Visual Basic and Macros from the Developer tab.