05-01-2020 02:08 PM
05-02-2020 07:37 AM
click on enable macro, if you don't find the enable macro then follow the steps
File > Option > Trust Center > Trust Center Settings > Macro Settings > Disable Macro With Notification
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more.
12-28-2020 03:09 PM
I am having a similar problem. We have an Excel file in a Dropbox folder. I am able to open it and run the macros. However, another person, opening the same file from their computer, receives the message that the macros are blocked to keep you safe. There is no button to allow the macros to run. In the Trust center settings, we both have block but notify selected. However, because the other person couldn't get the macros to run on her computer, she had setting at run all macros. Still, the message comes up when she opens the file and there is no way to run the macros. This is Office 365.