VBA & Macro Problems

How to Fix Excel Macros Automatically Disabled and Restore Access

Algirdas Jasaitis Oct 13, 2026 869 views

Question details

The user needs to restore access to Excel macros that are being automatically blocked despite the user trusting the files.

How to Restore Access When Excel Macros Are Automatically Disabled

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to run macros in personal or local workbooks, especially those downloaded from the internet or received via email.
Observed behavior: Excel automatically disables or blocks the macros, preventing execution due to Microsoft's security policies, downloaded-file protections, or organizational settings.

Before you start

Verify that the macro-enabled workbook comes from a trustworthy source, as enabling macros from unknown internet sources poses significant security risks to your device.

Solution 1Recommended

Unblock Macros for Downloaded Files

Use this solution if your workbook was downloaded from the internet and Windows has flagged it with a 'Mark of the Web', causing Excel to block its macros.

Modern versions of Windows and Microsoft Office automatically apply security flags to files downloaded from the web. To allow macros to run, you must manually remove this restriction from the file's properties menu.

Close the Workbook

Ensure the affected Excel file is completely closed before attempting to modify its properties.

Access File Properties

Locate the downloaded file in Windows File Explorer, right-click on the file, and select 'Properties' from the context menu.

Unblock the File

On the 'General' tab, navigate to the Security section at the bottom. Check the box labeled 'Unblock', then click 'Apply' and 'OK'.

Security Check: Only unblock files if you are absolutely certain the source is safe and the contained macro code is not malicious.

Solution 2

Add Folder to Trusted Locations

Designate a specific folder on your computer as a Trusted Location so any macro-enabled files saved there will run without security prompts.

Solution 3

Verify Organizational Policies

Use this approach if you are on a work computer and your local Trust Center settings are grayed out or fail to restore macro access.

Free Microsoft Office alternative

Try WPS Office for a Seamless Spreadsheet Experience

If strict Microsoft Excel security policies are disrupting your productivity, consider WPS Office as a free, lightweight, and easy-to-use alternative. It offers a familiar interface, high format compatibility, and a hassle-free environment for your everyday spreadsheet tasks.

1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
2. Install the Software: Run the installer and follow the on-screen prompts to complete the quick installation process.
3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing files to resume your work within a familiar, highly compatible interface.

Highly compatible with Microsoft Office formats, including .xlsx, .xlsm, and .csv.Lightweight software with fast installation and quick file loading speeds.Familiar user interface that ensures a seamless migration without a steep learning curve.Free to use for essential spreadsheet, document, and presentation tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why are my Excel macros suddenly disabled when they used to work fine?

Microsoft frequently updates its security protocols. A recent update changed the default behavior to automatically block VBA macros in files originating from the internet to better protect users against malicious attacks and ransomware.

Can I digitally sign my macros to prevent them from being blocked?

Yes. If you digitally sign your VBA project with a valid certificate, Excel will allow the macros to execute under strict security settings, provided the certificate is installed in your computer's Trusted Publishers list.

Is it safe to select 'Enable all macros' in the Excel Trust Center?

No, selecting 'Enable all macros' is highly discouraged. This setting bypasses all security warnings and makes your system vulnerable to dangerous code that can execute without your knowledge. It is safer to utilize Trusted Locations for your specific files instead.

Excel & Data Problems