Error message when trying to use macro

Occasional Visitor

This morning I have been getting the following error for all of my files that contains a macro:

 

SECURITY RISK: Microsoft has blocked macros from running because the source of this file is untrusted.

 

I was able to use the file earlier this week.  The file has always been saved in the same location in my OneDrive.  I have researched online and saw where you can go to the file properties from Windows Explorer and checked the box to unblock the file, but I am not given that option when I go to the file properties.

 

If someone has had this same problem, can you share how you solved it?

 

Thanks.

1 Reply

@ktroberts Open Excel. Go File--Options--Trust Center--Trust Center Settings--Macro Settings--Enable VBA Macros and then click OK.