Activating Macros on an Excel Spreadsheet in Excel for Mac environment

%3CLINGO-SUB%20id%3D%22lingo-sub-2012954%22%20slang%3D%22en-US%22%3EActivating%20Macros%20on%20an%20Excel%20Spreadsheet%20in%20Excel%20for%20Mac%20environment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2012954%22%20slang%3D%22en-US%22%3E%3CP%3EA%20group%20I%20am%20involved%20with%20utilizes%20and%20excel%20spreadsheet%20with%20macros%2C%20to%20send%20out%20weekly%20status%20emails.%20A%20number%20of%20us%20use%20it%20without%20problems.%3C%2FP%3E%3CP%3ERecently%2C%20I%20shared%20a%20version%20of%20this%20spreadsheet%20with%20someone%20who%20works%20on%20a%20mac.%3C%2FP%3E%3CP%3EHe%20hasn't%20been%20able%20to%20enable%20the%20content.%3C%2FP%3E%3CP%3EIs%20there%20a%20different%20procedure%20in%20a%20mac%20environment.%3C%2FP%3E%3CP%3EHe%20downloaded%20excel%20365%20for%20mac.%3C%2FP%3E%3CP%3EThanks%20for%20any%20assistance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDave%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2012954%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2013056%22%20slang%3D%22en-US%22%3ERe%3A%20Activating%20Macros%20on%20an%20Excel%20Spreadsheet%20in%20Excel%20for%20Mac%20environment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2013056%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F910514%22%20target%3D%22_blank%22%3E%40Golfing_Dave%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20enable%20macros%20on%20excel%20on%20mac%2C%20you%20can%20do%20it%20from%20the%20%3CSTRONG%3Edeveloper%20tab%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3EIf%20the%20developer%20tab%20is%20not%20in%20Ribbon%2C%20follow%20theses%20steps%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EClick%20on%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EExcel%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bin%20the%20menu%20bar%2C%20and%20then%20select%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EPreferences%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bin%20the%20dropdown.%20In%20the%20menu%2C%20click%20on%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ERibbon%20%26amp%3B%20Toolbar%3C%2FSTRONG%3E%3CSPAN%3E.%20In%20the%20right-hand%20list%2C%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EDeveloper%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bshould%20be%20at%20the%20bottom%2C%20click%20the%20checkbox.%20Finally%2C%20click%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ESave%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Band%20you%20should%20see%20the%20Developer%20tab%20show%20up%20at%20the%20end%20of%20the%20Ribbon.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E*%20If%20my%20post%20helped%20you%2C%20please%20click%20on%20like.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

A group I am involved with utilizes and excel spreadsheet with macros, to send out weekly status emails. A number of us use it without problems.

Recently, I shared a version of this spreadsheet with someone who works on a mac.

He hasn't been able to enable the content.

Is there a different procedure in a mac environment.

He downloaded excel 365 for mac.

Thanks for any assistance.

 

Dave

2 Replies

Hi @Golfing_Dave 

 

To enable macros on excel on mac, you can do it from the developer tab.

If the developer tab is not in Ribbon, follow theses steps:

 

Click on Excel in the menu bar, and then select Preferences in the dropdown. In the menu, click on Ribbon & Toolbar. In the right-hand list, Developer should be at the bottom, click the checkbox. Finally, click Save and you should see the Developer tab show up at the end of the Ribbon.

 

 

 

* If my post helped you, please click on like.

@Golfing_Dave Is suspect that macro security is set to "Disable all macros without notification".

 

On the Excel menu, press Preferences, then Security (in the Sharing and Privacy section) and choose to disable WITH notification. Upon opening an xlm file, he will be given the option to Enable the macro(s).

Screenshot 2020-12-24 at 07.47.11.pngScreenshot 2020-12-24 at 07.46.51.png

Screenshot 2020-12-24 at 07.50.31.png