VBA & Macro Problems

How to Enable Macros in the Latest Version of Excel

WPS Editor Oct 10, 2026 868 views

Question details

The user needs to know how to enable VBA macros in the newest version of Microsoft Excel to run automated scripts in their workbooks.

How to Enable Macros in the Latest Version of Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: The user is attempting to open or run a macro-enabled workbook, but the macros are blocked by Excel's default security settings.
Observed behavior: Excel automatically blocks macros to protect against malicious code, requiring the user to manually adjust settings in the Trust Center.

Before you start

Before modifying your macro settings, verify that the workbook comes from a reliable and trusted source, as enabling macros from unknown senders can expose your computer to malicious code.

Solution 1Recommended

Enable Macros via Excel Trust Center Settings

Use the built-in Trust Center to adjust macro permissions to a safe level, allowing you to selectively enable macros when needed.

The Trust Center is the primary location for managing security and privacy settings in Excel. By adjusting your macro settings here, you can balance functionality with system protection.

Access Excel Options

Open Microsoft Excel. Click on the 'File' tab located in the top-left corner of the ribbon, then select 'Options' at the very bottom of the left-hand menu.

Open Trust Center

In the Excel Options dialog box, select 'Trust Center' from the list on the left pane. Then, click the 'Trust Center Settings...' button on the right.

Adjust Macro Settings

Click on 'Macro Settings' in the left menu of the Trust Center window. Choose the option 'Disable VBA macros with notification'. This is the safest approach, as it prevents malicious scripts from running automatically but lets you enable trusted ones.

Restart and Enable Content

Click 'OK' to save your changes and restart Excel. When you open a trusted macro-enabled workbook, a yellow warning bar will appear at the top. Simply click 'Enable Content' to run the macros for that specific file.

Enable Macros via Excel Trust Center Settings

Security Warning: Avoid selecting 'Enable all macros' unless you are operating in a highly controlled environment, as this setting makes your system vulnerable to malicious workbooks.

Solution 2

Create a Trusted Location for Macro Workbooks

Designate a specific folder on your computer as a Trusted Location so any Excel file placed there will run macros automatically without security warnings.

Free Microsoft Office alternative

Try WPS Office for Secure and Lightweight Spreadsheet Management

If you want a hassle-free, highly compatible alternative to Microsoft Excel, WPS Office is an excellent choice. It offers robust spreadsheet tools, familiar interfaces, and secure document handling without the heavy resource usage.

1. Download the Installer: Visit the official WPS Office website and click the free download button to get the latest installation package.
2. Install WPS Office: Run the downloaded installer file and follow the simple on-screen instructions to set up WPS Office on your device.
3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Excel workbooks to enjoy a seamless, highly compatible editing experience.

Seamlessly open, edit, and save Microsoft Excel formats including .xlsx and .xlsmLightweight installation that runs swiftly on almost any computerCompletely free to download with a familiar tabbed interfaceBuilt-in robust security features to keep your files and data safe

microsoft office alternative - wps office

Frequently Asked Questions

Why are macros disabled by default in the latest version of Excel?

Microsoft Excel blocks macros by default to protect your computer from potentially malicious code. Cybercriminals often use VBA macros in email attachments to distribute malware, so requiring manual approval adds a necessary layer of security.

What is the safest macro setting to use?

The safest and most recommended setting is 'Disable VBA macros with notification'. This ensures macros do not run automatically, but it provides a clickable alert so you can manually enable macros only when you trust the workbook's source.

Can I enable macros for just one specific Excel file?

Yes. If your settings are configured to 'Disable with notification', opening a macro-enabled workbook will display a yellow Security Warning bar at the top of the sheet. Simply click 'Enable Content' on that bar to allow macros for that specific file during your session.

Why is the 'Enable all macros' option considered dangerous?

Choosing 'Enable all macros' forces Excel to run any VBA code silently in the background as soon as a file is opened. If you accidentally open an infected workbook downloaded from the internet, the malicious code will execute immediately without giving you a chance to stop it.

Excel & Data Problems