1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Trusted Locations dont work on Company Onedrive

There is a VBA Macro File that needs to be accessed by a few people but the Macros get blocked.

Policy is set to deactivate all Macros except digitally signed ones, which they are.

Trusted locations on network is set to allowed as well as access to the VBA-Projectobjectmodel.

If placed in trusted locations locally or the personal onedrive the Macros dont get blocked.

If placed in trusted locations on the company onedrive they do get blocked.

I tried the local path as well as the sharepoint url.

The creator of the file does not have that issue.

This has been done before and it worked. Im not aware of any changes that could have an effect.

Does aynone have an idea what the issue could be?

submitted by /u/10hNyancat
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#VBA Macro
#trusted locations
#blocked
#Company OneDrive
#Macros
#policy
#VBA-Projectobjectmodel
#digitally signed
#SharePoint
#network
#personal OneDrive
#local path
#file creator
#previously worked
#access
#changes