How to Enable a Macro in Excel, Word, and Other Applications

Macros can feel intimidating at first, but they're one of the most practical tools in any software power user's toolkit. Whether you're trying to automate repetitive tasks in a spreadsheet or run a script someone else built, understanding how to enable macros — and why they're disabled by default — puts you firmly in control.

What Is a Macro, Exactly?

A macro is a saved sequence of instructions that a program can execute automatically. Instead of clicking through the same ten steps every morning, you record or write those steps once, then trigger them with a single action.

In Microsoft Office applications like Excel and Word, macros are written in VBA (Visual Basic for Applications) — a scripting language built directly into the Office suite. Other applications use their own macro languages or automation frameworks, but the concept is the same: one trigger, many actions.

Why Are Macros Disabled by Default? 🔒

Macros are powerful, and that power cuts both ways. Because a macro can execute code automatically, malicious actors have historically embedded harmful scripts inside macro-enabled files. Opening a document and unknowingly running a macro that installs malware is a real, documented threat vector.

That's why Microsoft and most other software vendors disable macros by default. This isn't a bug or an oversight — it's a deliberate security boundary. Every time you enable macros, you're making a conscious decision to trust that code.

This context matters when you're deciding how broadly to enable them.

How to Enable Macros in Microsoft Excel

Excel gives you several levels of macro control, all managed through the Trust Center.

To enable macros for a single session:

1. Open the file. A yellow security bar appears at the top of the spreadsheet.
2. Click Enable Content.
3. Macros are now active for this session.

To change your default macro settings:

1. Go to File → Options → Trust Center → Trust Center Settings
2. Select Macro Settings from the left panel
3. Choose from four options:

The "Disable with notification" setting is the default for good reason — it keeps you informed without being fully restrictive.

How to Enable Macros in Microsoft Word

The process in Word mirrors Excel almost exactly. Word documents containing macros use the .docm file extension rather than the standard .docx format. If you open a .docm file, you'll see the same yellow notification bar.

Steps are identical:

• File → Options → Trust Center → Trust Center Settings → Macro Settings

If a colleague sends you a Word file and the macro bar doesn't appear, check whether the file was saved in a macro-enabled format to begin with.

Trusted Locations: A Smarter Middle Ground

Rather than enabling all macros globally, you can designate Trusted Locations — specific folders on your computer or network where macros are allowed to run without prompting.

This approach is commonly used in workplace environments where a team shares verified macro-enabled files stored in a controlled directory. Files outside that folder still go through normal security checks.

To add a trusted location:

• Trust Center Settings → Trusted Locations → Add new location

This keeps your security posture tighter while removing friction for files you already know are safe.

Enabling Macros in Google Workspace (Sheets and Docs)

Google Sheets and Google Docs handle automation differently. Instead of VBA, they use Google Apps Script — a JavaScript-based language that runs in the cloud.

Macros in Google Sheets are created and managed under Extensions → Macros. When you run a script for the first time, Google prompts you to authorize it, explaining exactly what permissions it needs (reading your spreadsheet data, accessing Drive, etc.).

You're not toggling a blanket on/off switch — you're reviewing and approving specific permission scopes. This is a fundamentally different model from the Office approach, and arguably more transparent for the average user.

Macro Security Across Different Skill Levels 🛠️

How you approach enabling macros reasonably depends on your comfort level and context:

• Beginner users working with files from unknown sources should leave defaults in place and only click "Enable Content" when they're confident about where the file came from.
• Intermediate users building their own macros for personal use can work with the notification-based default settings comfortably.
• Advanced users or IT administrators often configure Trusted Locations or use digitally signed macros to balance security with workflow efficiency across a team.

The "right" configuration isn't universal. An accountant running daily reports in a controlled Office environment has different needs than someone occasionally opening files emailed from external contacts.

What Determines Your Best Approach

Several factors shape how you should configure macro permissions:

• Where your files come from — internal, trusted sources versus external or unknown senders
• Your organization's IT policy — many businesses enforce macro settings via Group Policy, which may override anything you configure manually
• The software version you're running — Microsoft 365 has introduced additional layers of macro blocking, especially for files downloaded from the internet (flagged with a Mark of the Web)
• Whether you're building macros yourself or running someone else's
• Your operating system — macro behavior and file trust settings differ between Windows and macOS versions of Office

The steps above will get macros running in the most common scenarios. But how permissive or restrictive to be — and whether your specific file, application version, or workplace environment introduces additional layers — depends entirely on your own setup.