How To Enable Macros In Excel Windows 11: A Step-by-Step Guide

Home » How-To

Edgar Nicov

How-To

5 min. read

Published on October 24, 2025

Fix Windows errors with Fortect:
Fortect can repair common computer errors by scanning your entire system for damaged or missing OS files and replacing them with the original, working versions. Optimize your PC in 3 simple steps:

Download and Install Fortect on your PC
Use the PC Scan feature to look up any Windows issues (including drivers)
Right-click on Repair, and fix it within a few minutes.

Besides that, it helps you clean up junk files, fix stability problems, and get rid of annoying programs and malware traces.

Macros in Excel can automate repetitive tasks, saving you time and effort. However, they are often disabled by default for security reasons. This guide will walk you through the process of enabling macros in Excel on Windows 11, so you can take full advantage of this powerful feature.

Enabling macros is a straightforward process, but it’s crucial to understand the security implications. We’ll cover the necessary steps to allow macros while minimizing potential risks to your system. Let’s dive into how to enable macros in Excel on Windows 11.

How Do I Turn On Macros In Excel Windows 11?

Access the Trust Center Settings

Open Microsoft Excel.
Click on “File” in the top-left corner.
Select “Options” from the menu.
In the Excel Options window, click on “Trust Center.”
Click the “Trust Center Settings…” button.

Configure Macro Settings

In the Trust Center window, select “Macro Settings” from the left-hand menu.
Choose one of the following options based on your security preferences:

Disable all macros without notification: This is the most secure option and prevents all macros from running without any prompts.
Disable all macros with notification: This option disables macros but displays a security alert bar when a workbook containing macros is opened, allowing you to enable them on a case-by-case basis.
Disable all macros except digitally signed macros: This option allows macros that have been digitally signed by a trusted publisher to run.
Enable all macros (not recommended; potentially dangerous code can run): This is the least secure option and allows all macros to run without any prompts. Only select this if you fully trust the source of the Excel file.

If you choose “Disable all macros with notification,” ensure the “Trust access to the VBA project object model” checkbox is unchecked unless you have a specific need for it and understand the security implications.
Click “OK” to save your changes.
Click “OK” again to close the Trust Center window.

Trusted Locations (Optional)

If you frequently use macros from specific locations, you can add them as trusted locations to bypass the security warnings.

In the Trust Center window (File > Options > Trust Center > Trust Center Settings), select “Trusted Locations” from the left-hand menu.
Click “Add new location…”
Enter the path to the folder containing your trusted Excel files.
Optionally, check the “Subfolders of this location are also trusted” box.
Click “OK” to save the trusted location.
Click “OK” again to close the Trust Center window.

Tips for Macro Security

Only enable macros from trusted sources: Be cautious when opening Excel files from unknown or untrusted sources, as they may contain malicious macros.
Keep your antivirus software up to date: Antivirus software can help detect and prevent macro-based threats.
Consider using digitally signed macros: Digital signatures provide assurance that the macro code has not been tampered with since it was signed.
Regularly review your Trust Center settings: Make sure your macro security settings are appropriate for your needs and security preferences.

Here’s a comparison of the macro security levels in Excel:

Macro Security Level Comparison

Security Level	Description	Recommended Use
Disable all macros without notification	All macros are disabled. No warnings are displayed.	When you don’t need macros and want maximum security.
Disable all macros with notification	Macros are disabled, but a warning appears allowing you to enable them on a case-by-case basis.	When you occasionally need macros but want to be prompted before enabling them.
Disable all macros except digitally signed macros	Only macros signed by a trusted publisher are allowed to run.	When you use macros from trusted sources and want to ensure their integrity.
Enable all macros (not recommended)	All macros are enabled without any warnings. This is the least secure option.	Only if you fully trust all Excel files you open and understand the associated risks.

Taking Control of Excel Automation

Enabling macros in Excel Windows 11 allows you to unlock a world of automation and efficiency. By following these steps and understanding the security implications, you can safely and effectively use macros to streamline your workflow.

FAQ

How do I know if an Excel file contains macros? When you open an Excel file containing macros, Excel will typically display a security warning message if macros are disabled with notification. You can also check the file extension; macro-enabled files usually have the .xlsm extension.

Why are macros disabled by default in Excel? Macros are disabled by default to protect your computer from potentially malicious code. Macros can be used to automate tasks, but they can also be used to spread viruses or other malware.

What is a digitally signed macro? A digitally signed macro is a macro that has been verified by a trusted publisher. Digital signatures help ensure that the macro code has not been tampered with since it was signed.

Can I enable macros for just one Excel file? Yes, if you have “Disable all macros with notification” selected, you can enable macros for a specific file by clicking the “Enable Content” button in the security warning bar when you open the file.

What are the risks of enabling all macros? Enabling all macros can expose your computer to security risks, as any macro, even from untrusted sources, will be allowed to run. This increases the likelihood of malware infection.