Forum Discussion

Sarah1980's avatar
Sarah1980
Copper Contributor
Sep 27, 2026

Security risk - Microsoft has blocked macros

Hello. I have used 3 different macro spreadsheets from a developer through upwork for over a year with no problems. Last week I can no longer open the files. It comes up with a pick security risk - Microsoft has blocked macros from running because the source of this file is untrusted. 
I deleted a recent Microsoft update which I think caused the problem. I then redownloaded the files from upwork and was able to tick the unblock box through preferences. I was then able to use the files. Today however the warning has come up again and I can no longer use the files. I need to be able to use them for my work ASAP. Please help me. 

Macros and VBA

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Oct 01, 2026

    I suspect the VBA project of the files was signed with a digital signature which hasn't been time-stamped. If that signature expires, Excel will refuse to enable the macros.

    • Open the file
    • Open the VBA Editor (alt+F11)
    • Click on the name of the project in the Project Explorer
    • From the Menu, choose Tools, Digital Signature
    • Click Remove
    • Click OK
    • Close the VBA Editor
    • Save the file
    • Close it and open it again.