Enable Excel Macros for Users on a Network File Server
Question details
Enable an Excel workbook's macros for users accessing it from a network file server and manage workbook commands across an organization.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- An organization shares a macro-enabled workbook from a network file server and wants users to run its VBA code under managed security settings.
- Observed behavior
- A trusted server path may work for some users but not others because Excel trust settings and organizational policies can differ.
Identify the workbook's exact network path, the users who need access, and whether their Excel settings are managed by IT. Confirm that the file server location is restricted to people authorized to modify trusted workbooks.
Deploy a trusted network location through organizational policy
Use this approach when multiple users need to run trusted workbooks from the same controlled server folder.
In File Explorer, open the shared workbook's folder and note its UNC path, such as \\server\department\trusted-workbooks. Check that users can access the same path and that only authorized people can modify its contents.
In Group Policy Management, configure the Excel Trust Center trusted location settings for the target users. Enable network trusted locations if required, add the UNC path, and allow subfolders only if they are also controlled.
In Excel, open File > Options > Trust Center > Trust Center Settings > Trusted Locations to check the effective locations. A user-managed network location may also require the option to allow trusted locations on the network, unless policy controls it.
Have a target user reopen the workbook from the configured network path and test a known macro. If it remains blocked, ask IT to review the user's applied policy and Excel security settings.

Sign the VBA project with a trusted certificate
Use a trusted digital signature to identify the macro publisher and support an organization-wide macro policy.
Control workbook changes without relying on VBA security overrides
Use server permissions for access control and VBA events only for workbook behavior when macros are allowed to run.
Work with Shared Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing shared spreadsheets. Its Microsoft Office format support helps users move existing documents into their workflow, although it does not change Excel's macro policies.

Frequently Asked Questions
Why does a trusted network path work for one user but not another?
Trusted locations and macro policies can differ by user or be controlled by organizational policy. In Excel, check File > Options > Trust Center > Trust Center Settings > Trusted Locations, and ask IT to review the policies applied to each user.
Can I add a network folder as a trusted location myself?
If your organization permits it, open Excel's Trust Center Settings > Trusted Locations and add the network path. The setting that allows network trusted locations may also need to be enabled; organizational policy can restrict these changes.
Does signing a VBA project automatically make it trusted for everyone?
No. Users' systems must trust the publisher and permit the signed macros under their effective security policy. Ask IT to deploy the certificate trust and test with a target user.
Can VBA permanently disable Save As or Excel Options for all users?
No. VBA can change some workbook behavior while it runs, but it cannot reliably override security settings or permanently disable Excel Options for every user. Use server permissions for access control and provide a recovery method if a save event is canceled.
Will WPS Office change Excel's trusted location settings?
No. Excel trusted locations and macro policies must be configured in Excel or through organizational policy. WPS Office is an alternative for working with compatible spreadsheet files; VBA support can vary by WPS version and configuration.




