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...
Can you set up a trusted location (in Excel, Options, Trust center)? If yes, does it work if you store the file in that location?
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 😞
