Forum Discussion
DBOOTHV
Feb 13, 2023Copper Contributor
ENABLE MACROS - NOTHING WORK
Hi I need help with Macro settings I´m doing and Excel course in Coursera, when I downloaded the files that contain Macros Excel doesn´t allow me to run them. I have done the following and still doe...
- Feb 13, 2023
You didn't include the error message but my guess is you're getting a message saying macros are blocked because the workbook is not trusted. Essentially, you need to clear the author information from the file properties. Go to file | info | Properties | Advanced properties - remove the author information, save the workbook, close it and re-open it.
Patrick2788
Feb 13, 2023Silver Contributor
Glad it worked! I've seen it come up several times in the past few weeks. Clearing the author is the least amount of work needed to resolve it.
cnune02
Jun 12, 2023Copper Contributor
Patrick2788 It didn't work for me. Any other suggestions? I should mention the files I'm trying to enable are all from a Onedrive share file. Thanks in advance for your help.