Forum Discussion
Activating Macros on an Excel Spreadsheet in Excel for Mac environment
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).
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.
Riny_van_Eekelen Here is the file. I can use the same file on a Windows computer without any problem.
PraneethMutta I can open the file but want to have a look at the macro. Can't do that, because it is password protected. From the opening screen, I understand that the user has to select a file to be converted. So, I suspect the code reads out the folder path and filename. Folder paths are structured differently on a Mac are different than on a PC. Perhaps that's where it goes wrong.
Riny_van_Eekelen Have sent you the file. I was using this file perfect until I switched to MAC (office 365 from App store)
- This file is not supported to send via direct Message.