Forum Discussion

DBOOTHV's avatar
DBOOTHV
Copper Contributor
Feb 13, 2023

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's avatar
    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.

DBOOTHV's avatar
DBOOTHV
Copper Contributor
Thanks Patrick, it did work!. Couldn´t find this answer anywhere, not even in Chatgpt 🙂
Patrick2788's avatar
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's avatar
    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.

Share

Resources