•1 min read•from 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?
[link] [comments]
Want to read more?
Check out the full article on the original site
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