Forum Discussion
Enabling Macros in Excel for Mac version 16.52
Cannot download and open an excel file with macros in edit mode. File won't open other than Read Only even after changing the options in Excel Preferences >Security>Enable all macros I have updated...
There is no "Trust Center" in Office for the Mac.
I have tried > Tools > Security Options or Excel > Preferences > Security Options
the above has not allowed access to macros - can only save the file in Read Only mode
I have tried > Tools > Security Options or Excel > Preferences > Security Options
the above has not allowed access to macros - can only save the file in Read Only mode
Wait, the issue was with the file being read-only. Click the File tab of the ribbon, select the Info option, click the "Protect workbook" drop-down. Is the "Always open read-only" item highlighted by any chance?
As you can see by the attached screenshot, no the Always Read Only is not highlighted or ticked.
It appears there is no fix for this issue 😞
