VBA & Macro Problems

How to Disable Office 365 Macros Using the Registry

Algirdas Jasaitis Oct 19, 2026 869 views

Question details

The user needs to disable VBA macros across mixed Microsoft Office 365 editions using the Windows Registry because Group Policy is unavailable or not supported for their licenses.

How to Disable Office 365 Macros Using the Registry

Product: Microsoft Office 365
Device & OS: Windows
Scenario: Enforcing macro security restrictions across an organization with mixed Office licenses without relying on Group Policy capabilities.
Observed behavior: The user requires a registry-based method to effectively block all VBA macros with or without user notification across Word, Excel, and other Office applications.

Before you start

Before modifying the Windows Registry to disable macros, launch the Registry Editor and export a backup of the existing HKEY_LOCAL_MACHINE\Software\Policies tree to safely revert changes if a configuration error occurs.

Solution 1Recommended

Disable Office 365 Macros via Registry Editor

Use this method to manually configure the VBAWarnings registry key, allowing you to disable macros for the current user or the local machine without needing Group Policy access.

The VBAWarnings registry value allows administrators to control macro execution manually. Setting this value effectively mirrors the macro security options found in the Office Trust Center. By creating and configuring this specific DWORD value, you can securely manage mixed Office editions.

You can choose to apply this policy machine-wide by using the HKEY_LOCAL_MACHINE path, or limit it to the currently logged-in user by using the HKEY_CURRENT_USER path.

Open Registry Editor

Press the Windows key + R to open the Run dialog, type 'regedit', and press Enter to launch the Registry Editor. Click 'Yes' if prompted by User Account Control.

Navigate to the Office Security Key

In the Registry Editor, navigate to 'HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Office\16.0\security' to apply the change for all users. If you only want to affect the current user, go to 'HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\16.0\security' instead. If the 'security' key does not exist, right-click the '16.0' folder, select New > Key, and name it 'security'.

Create the VBAWarnings Value

Right-click on an empty space in the right-hand pane of the 'security' key, select 'New', and then click 'DWORD (32-bit) Value'. Name this new value 'VBAWarnings' and press Enter.

Modify the Value Data

Double-click the newly created 'VBAWarnings' value. In the Value data box, type '4' to disable all VBA macros without notification. Click 'OK' to save the changes.

Restart Office Applications

Close the Registry Editor. Ensure you completely close and reopen Word, Excel, or any other Office applications for the registry changes to take effect. Test with a macro-enabled file to verify.

Disable Office 365 Macros via Registry Editor

Macro Settings Values Overview: When editing the VBAWarnings key, setting the data to 2 disables macros but displays a warning, setting it to 3 allows only digitally signed macros, and setting it to 4 disables all macros without notification.

Free Microsoft Office alternative

Switch to WPS Office for a Secure and Lightweight Experience

Managing complex registry keys and Group Policies for mixed Office 365 licenses can be time-consuming and prone to errors. WPS Office provides a free, lightweight alternative with accessible security features, intuitive macro management directly from the user interface, and seamless compatibility with Microsoft formats.

1. Download the Installer: Visit the official WPS Office website and click the free download button to get the lightweight installer.
2. Install the Suite: Run the downloaded file and follow the quick setup instructions to install WPS Office on your Windows device.
3. Open and Manage Files securely: Launch WPS Office to instantly open your existing macro-enabled documents and easily configure security permissions via the built-in Developer settings.

Free to use with a comprehensive suite of Word, Excel, and PowerPoint alternativesSeamless format compatibility with Microsoft Office files (.xlsx, .docx, .pptx, .xlsm)Lightweight installation process that won't slow down your operating systemSimple and highly accessible macro security settings available without registry edits

microsoft office alternative - wps office

Frequently Asked Questions

Why use the registry instead of Group Policy to disable macros in Office?

Group Policy management for Office macros typically requires E3 or higher enterprise licenses. If your organization relies on mixed Office editions (like a combination of ProPlus, Business, and standard versions) or lacks active directory Group Policy capabilities, the Windows Registry provides a universal and reliable method to enforce macro security.

What is the difference between HKEY_LOCAL_MACHINE and HKEY_CURRENT_USER for macro settings?

Applying the VBAWarnings key in the HKEY_LOCAL_MACHINE path enforces the macro policy for all users who log into that specific computer. Placing it in the HKEY_CURRENT_USER path only applies the macro restrictions to the specific user profile that is currently logged in, leaving other accounts on the same machine unaffected.

How do I configure the registry to only allow digitally signed macros?

To allow only digitally signed macros, navigate to the exact same security registry path (HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Office\16.0\security), double-click your created VBAWarnings DWORD value, and change its Value data to 3 instead of 4. This will block unsigned macros while permitting verified, digitally signed ones to run.

Excel & Data Problems