How to Enable Macros in Excel, Word, and Other Office Apps

Macros can feel intimidating — especially when software warns you about them with alarming yellow banners. But once you understand what they are and how enabling them actually works, the process is straightforward. The trickier part is knowing which method fits your situation.

What Are Macros and Why Are They Disabled by Default?

A macro is a recorded or written sequence of instructions that automates repetitive tasks. In Microsoft Office apps like Excel and Word, macros are typically written in VBA (Visual Basic for Applications). In Google Sheets, they use Google Apps Script. In other tools, macros might work through built-in recorders or third-party extensions.

The reason macros are disabled by default comes down to security. A macro is essentially executable code — and malicious macros embedded in documents have historically been used to spread malware. So by default, most office software blocks them until you explicitly give permission.

That default-off behavior is intentional and protective. Enabling macros should always be a deliberate choice, not an automatic one.

How to Enable Macros in Microsoft Excel and Word

This is where most people need help. Microsoft 365 and standalone Office versions use the Trust Center to manage macro settings.

Step-by-Step: Enabling Macros via the Trust Center

1. Open Excel or Word
2. Go to File → Options
3. Select Trust Center from the left panel
4. Click Trust Center Settings
5. Choose Macro Settings from the left menu

You'll see four options:

For most users, "Disable all macros with notification" is the practical balance — you get the security prompt and can make a case-by-case decision.

The Yellow Bar Method

If you open a file that contains macros, you'll often see a yellow Security Warning bar at the top of the document. Clicking "Enable Content" activates macros for that file only, without changing your global settings. This is the most common way everyday users enable macros on a per-file basis.

Trusted Locations

If you regularly work with macros from a specific folder (your own scripts, internal company tools), you can add that folder as a Trusted Location inside the Trust Center. Files opened from a Trusted Location run macros automatically without any prompts.

This is useful for workflow automation where prompts would interrupt a process — but it means those files bypass security checks entirely, so it should only be used for locations you fully control.

Enabling Macros in Google Sheets

Google Sheets handles macros differently. Macros are created and managed through Extensions → Macros, and they run via Google Apps Script — a JavaScript-based environment rather than VBA.

When you run a macro for the first time (especially one that accesses external data or your Google account), Google will prompt you to authorize permissions. This is Google's version of the "enable macros" step.

To record a new macro: Extensions → Macros → Record Macro. To manage or run existing ones: Extensions → Macros → Manage Macros.

There's no global on/off switch like in Microsoft Office. Instead, authorization happens per script, per account.

Enabling Macros in LibreOffice

LibreOffice uses a macro security level system found under:

Tools → Options → LibreOffice → Security → Macro Security

Four levels are available — Very High, High, Medium, and Low — controlling whether macros from unknown sources are allowed to run. Setting it to Medium gives you a prompt each time, similar to the yellow-bar behavior in Excel.

Variables That Change How This Works 🔧

How you enable macros — and whether it's the right call — depends on several factors:

• Your Office version: Microsoft 365 settings differ slightly from Office 2019 or 2016. Some older versions have fewer Trust Center options.
• Whether you're on a managed device: IT-administered computers at organizations often have macro policies enforced via Group Policy. In those environments, individual users may not be able to change macro settings at all — or certain options may be greyed out.
• The source of the macro file: A macro you wrote yourself carries very different risk than one that arrived in an unsolicited email attachment.
• Your operating system: macOS versions of Excel have a slightly different Trust Center layout. Some VBA features available on Windows don't exist on Mac.
• The application: Each tool — Excel, Word, Google Sheets, LibreOffice Calc — has its own macro engine, permission model, and security architecture.

What "Digitally Signed" Macros Mean

The option to allow only digitally signed macros is often overlooked. A digital signature is a certificate attached to the macro that verifies its source. Organizations that distribute internal macro tools to employees often sign them, allowing those macros to run on "High" security settings without requiring users to lower protections globally.

If your workplace provides macro-enabled files regularly, asking your IT team whether those files are signed — or whether there's a Trusted Publisher already configured — may be a cleaner solution than adjusting macro settings manually.

The Part That Depends on Your Setup

Enabling macros is technically simple. What varies significantly is the context: whether you're on a personal machine with full control, a corporate device with enforced policies, an older version of Office with different options, or a non-Microsoft environment entirely. The same yellow bar in Excel can mean different things depending on where the file came from, how your Trust Center is configured, and whether your organization's policies are in play.

Understanding those layers is what separates a one-click fix from a situation that needs a different approach altogether. 🖥️