Excel Macros block

Good day

 Iam having a problem. Microsoft launched the Macros block  update recently. Unfortunately, all macros from our server are now being treated as untrusted sources. I have added the network drives to the trusted location point, if i right-click on the files and go to properties, there is no option to unblock the files. Is there a permanent method where i can set the files from a network drive as safe. As a company we work with files primarily from the server and run python from there so the option of copying the files to the local pc is not an option