Fix a Read-Only Macro-Enabled Workbook in Excel for Mac
Question details
Determine why a macro-enabled workbook opens as read-only or produces an error when content is enabled 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.
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.
Check the Workbook for Read-Only Restrictions and ActiveX Controls
Identify whether file permissions, workbook protection, or unsupported controls could explain the behavior.
In Finder, select the workbook and choose File > Get Info. Check whether Locked is selected and review Sharing & Permissions for your account.
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.
In Excel, open Settings or Preferences > Ribbon & Toolbar, select Developer, and save the change.
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.

Replace ActiveX Controls in Excel for Windows
Use this option when the workbook contains ActiveX controls and needs to work on a Mac.
Try Viewing the Workbook in Excel for the Web
Use the web version as a viewing or basic editing alternative when desktop Excel cannot open the workbook as expected.
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.

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.




