Forum Discussion

Copper Contributor

Feb 13, 2023

Solved

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

Macros and VBA

office 365

Patrick2788
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

Silver Contributor

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.

Athulya2220
Copper Contributor
Jan 18, 2024
Thanks a lot after trying out all the methods this is the one that finally worked for me!!!!!!! Patrick2788
Berry_Source
Copper Contributor
Oct 06, 2023
I followed your instructions and it didn't work for me. I deleted the author...any other suggestions? the "enable VBA macros" does not work either. SOS!!
DBOOTHV
Copper Contributor
Feb 13, 2023
Thanks Patrick, it did work!. Couldn´t find this answer anywhere, not even in Chatgpt 🙂
- Patrick2788
  Silver Contributor
  Feb 13, 2023
  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
    Copper Contributor
    Jun 12, 2023
    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.