Jul 23 2022 10:01 AM
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.
Jul 24 2022 04:50 AM
@ktroberts Open Excel. Go File--Options--Trust Center--Trust Center Settings--Macro Settings--Enable VBA Macros and then click OK.