Forum Discussion

ktroberts's avatar
ktroberts
Copper Contributor
Jul 23, 2022

Error message when trying to use macro

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.

excel
Macros and VBA
  • cool2021's avatar
    cool2021
    Iron Contributor
    Jul 24, 2022

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

Resources