VBA & Macro Problems

Fix Excel VBA Macros Blocked Without an Unblock Option

Algirdas JasaitisAlgirdas Jasaitis Oct 28, 2026 874 views

Question details

The user is unable to run Excel VBA macros from files located on a company network server because they are blocked, the file properties lack an Unblock option, and adding the path to Trusted Locations results in a security error.

Fix Excel VBA Macros Blocked Without an Unblock Option
Product
Microsoft Excel
Device & OS
Windows
Scenario
Accessing and running a macro-enabled workbook that is stored on a shared company network server.
Observed behavior
Excel blocks the VBA macros, the Windows file Properties dialog does not display an Unblock option, and adding the network location to Excel's Trusted Locations yields a security error.
Before you start

Ensure you have the exact file server name or UNC path (e.g., \\fileserver\networkdirectory) rather than just the mapped drive letter, and verify you have permission to modify Excel Trust Center settings.

Solution 1Recommended

Add the Network UNC Path to Excel Trusted Locations

Bypass the security error by using the actual server name (UNC path) instead of a mapped drive letter when configuring Excel's Trusted Locations.

Excel's Trust Center often rejects mapped drive letters (such as Z:\) for network locations due to security protocols. Specifying the Universal Naming Convention (UNC) path resolves this security error.

1
Enable network trusted locations

Open Excel, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations, and check the box for 'Allow Trusted Locations on my network (not recommended)'.

2
Add new location

Click 'Add new location...' to open the Microsoft Office Trusted Location dialog box.

3
Enter the UNC path

Instead of browsing to a mapped drive, manually type the exact UNC path of the network directory (e.g., \\servername\sharedfolder) into the path field and check 'Subfolders of this location are also trusted'.

4
Save and restart

Click OK to save the new settings, close all open Excel windows, and reopen your macro-enabled workbook from the network.

Add the Network UNC Path to Excel Trusted Locations
Path Accepted: Once the UNC path is successfully added, Excel will recognize the network location as safe, and macros will run without needing the missing 'Unblock' option.
Free Microsoft Office alternative

Experience Hassle-Free Spreadsheets with WPS Office

If Microsoft Excel's strict network macro policies and missing unblock options are slowing down your workflow, try WPS Office. It provides a lightweight, highly compatible alternative for viewing and editing macro-enabled workbooks without constantly battling complex network security configurations.

  1. 1. Download and Install: Download WPS Office Free from the official website and complete the straightforward installation process.
  2. 2. Open your workbook: Launch WPS Spreadsheets and open your network-stored macro workbook.
  3. 3. Enable Macros: Follow the simple on-screen prompt to enable macros securely without needing to navigate complex trust center menus.
Free and lightweight office suiteExcellent compatibility with Microsoft Excel formats including .xlsm and .xlsxIntuitive interface with a familiar layout to reduce learning curvesSeamlessly handles VBA macros to support your essential daily tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why is the Unblock option missing in the file properties?

The Unblock option typically appears for files downloaded from the internet that carry the 'Mark of the Web' tag. Files accessed directly from a local network share or intranet often do not receive this tag, meaning the option won't appear even though Excel applies network security restrictions.

What is a UNC path and how do I find it?

A UNC (Universal Naming Convention) path points to a network resource using the server name rather than a mapped drive letter, formatted as \\ServerName\ShareName. You can find it by opening the Windows Command Prompt and typing 'net use' to see the remote server names mapped to your drive letters.

Is it safe to allow trusted locations on my network?

Yes, provided the network location is an internal company server managed by your IT department and access is strictly controlled. You should avoid trusting public, unknown, or unsecured network folders to protect your computer from malicious code.