Forum Discussion
Golfing_Dave
Dec 23, 2020Copper Contributor
Activating Macros on an Excel Spreadsheet in Excel for Mac environment
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...
Riny_van_Eekelen
Dec 24, 2020Platinum Contributor
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).
- PraneethMuttaAug 19, 2021Copper ContributorThere is no change seen even after enabling Macros.
- Riny_van_EekelenAug 19, 2021Platinum Contributor
PraneethMutta Can't really tell what's causing this without seeing the file. Send it to me via a DM if you don't want to upload it to the public space.
- PraneethMuttaAug 19, 2021Copper Contributor
Riny_van_Eekelen Here is the file. I can use the same file on a Windows computer without any problem.