Enabling Macros

Occasional Contributor

Questions regarding macros being blocked.

 

An Excel workbook with macros is stored in a "trusted location" in my OneDrive folder.  When I load this program I get the warning message that there is dangerous content but there is no option to enable the content.  (I wrote the VBA code and know it is safe.)  This program used to load and execute with no hassle.

 

Why does Excel ignore the fact that the file is in a trusted location?  Why is there no option to enable the macros at the end of the warning?  Does Protected Mode create these problems?

 

Maybe I need to start over in Trust Center.  Is there any way to reset everything in the Trust Center to default values?

 

Thanks.

0 Replies