Forum Discussion
Macros Enabled File Not working Properly on One drive shared folder
Sharing the workbook gives colleagues access to the file, but it does not automatically establish trust in its VBA code. Also, a Trusted Location configured on your computer is not automatically configured for every recipient. First confirm how an affected user opens the workbook: browser download, synced local folder, or Open in Desktop App. Excel for the web cannot run VBA. For a trusted OneDrive workbook, Microsoft specifically recommends Open in Desktop App instead of downloading a separate browser copy that may receive Mark of the Web. Test that route on one affected device. If the warning remains, record the exact file path and ask IT to inspect the effective macro and Trusted Location policies on that device. For wider deployment, consider signing the VBA project and having IT distribute the trusted publisher certificate. Avoid enabling all macros or trusting an entire shared drive merely to suppress the warning.