[ms office - o365] Allow Macros for 1 File

[DalekSec]

Morning All,

 

We have a stock order form that uses a macro, which means it can't be loaded in the webview.

 

When downloaded Office see's it as a untrusted file and blocks the macros, meaning no one can order stock. There is a quick workaround of Properties > Unblock. (https://answers.microsoft.com/en-us/msoffice/forum/all/i-want-to-unblock-macros-on-a-single-file-and-the/5a2c9474-7641-44ac-9f79-f213ff78dd95#:~:text=Open%20Windows%20File%20Explorer%20and,Unblock%20checkbox%20and%20select%20OK.)

 

But not easy to use in the field. Anyone know how i can easily allow a single file to be allowed without the need to unblock it?

 

Have another issue with it not working on iPads as doesnt work with the Macro... but Accounts don't want to remove the macro (which is a drop down)

 

Thanks

 

Alex

[5tu]

You can use GPO / Intune Office Trust Center settings to set the https SharePoint location of the file as trusted.

[DalekSec]

Just to clarify i go to : Configuration Profiles - Settings- Excel Options > Security > Trust Center > Trusted Locations

 

Then just put in the URL of our sharepoint?

[5tu]

Yep that's right. Wildcards also work too which is helpful when targeting locations in user OneDrives - e.g. https://-my.sharepoint.com/personal/*/Documents/Documents/TrustedDir

[DalekSec]

Amazing that worked thank you! Had to add the wildcard to get it to work...

[5tu]

@DalekSec can't believe it but this solution of using wildcards in Trusted Location paths has recently stopped working for us. Unsure if a Microsoft update has killed it or not.

 

Can I ask if it's still working for you? (Assuming you're using wildcards in OneDrive paths)

[DalekSec]

I've not had anyone report issues, will let you know if pops back up