Forum Discussion

AyushSomani's avatar
AyushSomani
Copper Contributor
Nov 11, 2026

Macros Enabled File Not working Properly on One drive shared folder

I have created an Excel file with VBA macros enabled and uploaded it to a shared OneDrive folder so that other users with access to the folder can open and use it. However, whenever a user opens the file, they receive a prompt stating that the macros have been blocked because the file is from an untrusted source.I have already added the file location to the Trusted Locations list via the Trust Center, but the issue still persists. Kindly help me resolve this so that all users can open and use the file properly without the macro-blocking prompt.

2 Replies

  • OwenLanty's avatar
    OwenLanty
    Brass Contributor

    On one affected PC, open the workbook's Properties dialog and check for an Unblock checkbox at the bottom. A browser-downloaded copy can carry Mark of the Web even when your own synced folder is trusted.

  • 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.