VBA & Macro Problems

Enable Excel Macros for Users on a Network File Server

Steven ParkerSteven Parker Nov 18, 2026 868 views

Question details

Enable an Excel workbook's macros for users accessing it from a network file server and manage workbook commands across an organization.

Enable Excel Macros for Users on a Network File Server
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.
Before you start

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.

Solution 1Recommended

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.

1
Confirm the server path

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.

2
Configure the policy

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.

3
Check user settings

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.

4
Test with a user account

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.

Deploy a trusted network location through organizational policy
Trust only controlled folders: A trusted location can allow active content in files stored there to run. Do not use a broadly writable network folder as a trusted location.
Free Microsoft Office alternative

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.

Open and edit shared spreadsheets in a familiar interfaceCompatible with Microsoft Excel formats, including XLSX and XLSMFree and lightweight for everyday office tasksUse existing Office files when moving to WPS Office
microsoft office alternative - wps office

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.