How to Enable Macros in Microsoft Office and Other Applications
Macros are one of those features that sound intimidating but become incredibly useful once you understand what they actually do — and how to turn them on safely. Whether you're working in Excel, Word, or another application, enabling macros follows a similar logic across platforms, though the exact steps vary depending on your software version and security settings.
What Are Macros, and Why Are They Disabled by Default?
A macro is a saved sequence of commands or actions that runs automatically, letting you automate repetitive tasks. In Microsoft Excel, for example, a macro might format an entire spreadsheet, run calculations, and generate a report — all with a single click.
The reason macros are disabled by default comes down to security. Macros can execute code, which means a malicious macro embedded in a file could cause real harm to your system. Microsoft and other software vendors made the conservative choice to block them automatically, requiring users to consciously opt in.
This is worth keeping in mind throughout: enabling macros is a deliberate action, and the level of access you grant matters.
How to Enable Macros in Microsoft Excel or Word (Windows)
This is the most common scenario. Microsoft 365 and standalone Office versions (2016, 2019, 2021) all use a similar process.
Method 1: Enable Macros When Opening a File
When you open a file containing macros, a yellow security warning bar typically appears beneath the ribbon, reading: "SECURITY WARNING: Macros have been disabled."
- Click Enable Content to allow macros for that file only
- This grants trust to that specific document without changing your global settings
This is the recommended approach for most users — it's selective and doesn't lower your overall security posture.
Method 2: Change Macro Settings in the Trust Center
If you need macros enabled more broadly, or if the warning bar isn't appearing:
- Open Excel or Word
- Go to File → Options → Trust Center
- Click Trust Center Settings
- Select Macro Settings from the left panel
- Choose your preferred setting
| Setting | What It Does |
|---|---|
| Disable all macros without notification | Blocks all macros silently |
| Disable all macros with notification | Blocks macros but shows the warning bar ✅ |
| Disable all macros except digitally signed | Allows macros from verified publishers only |
| Enable all macros | Runs all macros without prompting ⚠️ |
The second option (disable with notification) is the default for good reason — it keeps you in control. The fourth option (enable all) is generally not recommended unless you're in a tightly controlled environment and know exactly what files you're opening.
How to Enable Macros on a Mac (Microsoft Office)
The process is similar but located slightly differently:
- Open Excel or Word
- Go to Excel (or Word) → Preferences → Security
- Under Macro Security, choose your preferred level
- Restart the application if prompted
🖥️ Note that macro functionality on Mac has historically been more limited than on Windows, particularly for complex VBA-based macros. Some macros written for Windows may not run identically on macOS.
Enabling Macros in Google Sheets
Google Sheets uses a different system. Instead of VBA (Visual Basic for Applications), it uses Google Apps Script, which is JavaScript-based.
To run macros in Google Sheets:
- Go to Extensions → Macros → Record Macro (to create one) or Manage Macros (to run existing ones)
- When running a macro for the first time, you'll be prompted to authorize permissions
- Review the permissions requested, then click Allow
Because Apps Script runs in the cloud rather than locally, the security model differs from Office. However, you should still review what permissions a script is requesting before approving, especially with scripts you didn't write yourself.
Trusted Locations: A More Controlled Approach
If you regularly work with macro-enabled files stored in a specific folder, Trusted Locations offer a cleaner solution than broadly enabling macros:
- In the Trust Center (same path as above), select Trusted Locations
- Click Add new location
- Browse to the folder where your trusted macro files are stored
Files opened from that folder will run macros automatically, while files from other locations still trigger the standard security prompt. This is particularly useful in workplace environments where a team shares a set of approved macro-enabled templates.
File Formats and Macros: A Common Stumbling Block
One frequently overlooked issue: standard Office file formats don't support macros.
.xlsx(Excel) and.docx(Word) cannot contain macros- Macro-enabled files use
.xlsm(Excel) and.docm(Word) - If you save a macro-containing file as
.xlsx, the macros will be stripped out
If your macros aren't persisting after saving, this is often the reason.
The Variables That Change Your Experience
How macro enablement actually works for you depends on several factors:
- Your Office version — older versions (pre-2016) have different Trust Center layouts
- IT/admin policies — in corporate environments, macro settings may be locked by group policy and can't be changed by individual users
- File origin — files downloaded from the internet receive a Mark of the Web tag that triggers stricter security handling than locally created files
- Operating system — Mac and Windows handle VBA macros differently, and some features don't translate between platforms
- The macro's complexity — simple recorded macros behave differently from custom VBA scripts, which may require additional permissions or references
Someone enabling macros for a single trusted Excel template they built themselves is in a very different situation from someone who received a macro-enabled file by email from an unknown sender. The technical steps may look the same — but what's appropriate to enable, and how cautiously to proceed, depends entirely on that context.