Enabling Macros in Excel for Mac version 16.52

%3CLINGO-SUB%20id%3D%22lingo-sub-2673948%22%20slang%3D%22en-US%22%3EEnabling%20Macros%20in%20Excel%20for%20Mac%20version%2016.52%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2673948%22%20slang%3D%22en-US%22%3E%3CP%3ECannot%20download%20and%20open%20an%20excel%20file%20with%20macros%20in%20edit%20mode.%20File%20won't%20open%20other%20than%20Read%20Only%20even%20after%20changing%20the%20options%20in%20Excel%20Preferences%20%26gt%3BSecurity%26gt%3BEnable%20all%20macros%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20updated%20to%20the%20latest%20Office%20365%20for%20Mac%2C%20excel%20version%2016.52%2C%20run%20through%20all%20the%20suggestions%20again%20under%20Developer.%20Still%20cannot%20get%20the%20file%20to%20enable%20macros%3F%3F%3C%2FP%3E%3CP%3EI'm%20using%20MacBook%20Pro%20with%20macOS%20Big%20Sur%20Version%2011.5.2%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20attached%20file%20I'm%20trying%20to%20open%20in%20edit%20mode%20to%20enable%20macros%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2673948%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

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 to the latest Office 365 for Mac, excel version 16.52, run through all the suggestions again under Developer. Still cannot get the file to enable macros??

I'm using MacBook Pro with macOS Big Sur Version 11.5.2 

See attached file I'm trying to open in edit mode to enable macros

6 Replies
Does Mac have a security options for files downloaded from websites like Windows has: https://jkp-ads.com/Articles/Excel-Add-ins-fail-to-load.asp

HI @Jan Karel Pieterse 

Thanks for responding so quickly.

 

 

Mac does have security options, but I have tried all those and Macro's still won't work.

 

cheers Kim

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
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