Macros Settings Windows 10: How to Find and Use Them

VBA & macros · Updated November 22, 2026

In Windows 10, “macros settings” usually refers to the Macro Settings pane in Microsoft Office (Word, Excel, PowerPoint) or the macro recording features in apps like Notepad++ or AutoHotkey. There is no single built-in Windows 10 control panel for macros; instead, you adjust them per application. This article explains where to find macro settings in Office 365/2019 on Windows 10, how to enable or disable macros safely, and how to record your own.

What Are Macros and Why Do They Matter?

A macro is a recorded sequence of actions—keystrokes, mouse clicks, or formatting commands—that you can replay with a single command or button. In Windows 10, macros are most commonly used in Microsoft Office to automate repetitive tasks like formatting a report or inserting a signature block. They are stored as VBA (Visual Basic for Applications) code inside a document or a global template. Macros can save hours of work, but they also carry security risks because they can run arbitrary code—so Windows 10 and Office treat them as potentially dangerous.

Where to Find Macro Settings in Office on Windows 10

In Microsoft Office (Word, Excel, PowerPoint, Outlook) on Windows 10, the macro settings are inside the Trust Center. Here’s the exact path for Microsoft 365 or Office 2019/2021 on Windows:

  1. Open any Office app (e.g., Word).
  2. Click File > Options.
  3. Select Trust Center from the left sidebar.
  4. Click the Trust Center Settings button.
  5. Choose Macro Settings from the left menu.

You’ll see four options:

  • Disable VBA macros without notification – blocks all macros silently.
  • Disable VBA macros with notification – blocks macros but shows a yellow bar offering to enable them (default).
  • Disable VBA macros except digitally signed macros – only runs macros signed by a trusted publisher.
  • Enable VBA macros – runs all macros; not recommended for security.

Additionally, there is a checkbox for Trust access to the VBA project object model—leave it unchecked unless you’re a developer, because it allows programs to manipulate VBA code.

How to Record a Macro in Windows 10

In Excel or Word, you can record a macro without writing code. Go to View > Macros > Record Macro. Give it a name (no spaces), assign a shortcut key (e.g., Ctrl+Shift+R), and choose whether to store it in This Workbook or Personal Macro Workbook (the latter makes it available across all files). Perform your actions, then click Stop Recording. To run it, press the shortcut or go to View > Macros > View Macros and select it.

Note: Recording is not available in Excel for the web or on Mac in the same way—on Mac, you must write VBA manually or use third-party tools.

Common Problems and Fixes for Macro Settings

  • Macros are greyed out – This happens if the file is opened in protected view or if the document is from the internet. Click Enable Editing in the yellow bar, or right-click the file > Properties > Unblock.
  • Macros don’t run after enabling – Check if the file is saved as .xlsm or .docm (macro-enabled). Saving as .xlsx or .docx strips macros.
  • Security warning appears every time – If you trust the source, you can add the folder to Trusted Locations in the Trust Center (File > Options > Trust Center > Trusted Locations).
  • Can’t record in Excel 365 – The recording feature is still present in desktop Excel 365, but if you’re using Excel for the web, it’s missing. Use the desktop app.

Macro Settings in Other Windows 10 Apps

Outside Office, “macros” often refers to keyboard automation:

  • AutoHotkey – A free scripting language. You edit a .ahk file with Notepad, then double-click to run. There is no settings menu; you write hotkeys like ^j::Send Hello.
  • Notepad++ – Has a built-in macro recorder under Macro menu. Record, save, and assign a shortcut via Macro > Modify Shortcut.
  • Logitech or Razer gaming mice – Their software (Logitech G HUB, Razer Synapse) has macro tabs where you assign key sequences to buttons. These are stored per-device, not in Windows.

Windows 10 itself doesn’t have a universal macro recorder. For system-wide automation, you’d need third-party tools like AutoHotkey or Power Automate Desktop (free from Microsoft, but not preinstalled).

Safety and Security: What You Must Know

Macros are a common vector for malware. A malicious macro can delete files, send emails, or install ransomware. Follow these rules:

  • Never enable macros in documents from unknown sources, especially email attachments.
  • Keep the default setting Disable with notification so you see a prompt.
  • Only enable macros if you know the author and the file came from a trusted channel.
  • Digitally signed macros are safer, but a signature only proves the author, not that the code is harmless.
  • If you write your own macros, back up your files before testing—macros cannot be undone with Ctrl+Z.

If you receive a file with a macro and you’re unsure, open it in Protected View (right-click > Open in Protected View) and inspect the VBA code: press Alt+F11 in Office to open the VBA editor, then review modules. If you see suspicious commands like Shell or DeleteFile, close without saving.

Alternatives to Macros in Windows 10

If macros feel risky or complicated, consider these built-in alternatives:

  • Quick Access Toolbar – Add frequently used commands (e.g., Paste Values) with one click. No code needed.
  • Power Automate Desktop – Microsoft’s free RPA tool for Windows 10. It uses a drag-and-drop flow designer, not VBA, and can automate any app.
  • Task Scheduler – For running scripts or programs at specific times, not for recording clicks.
  • Excel Tables and Formulas – Many repetitive tasks can be replaced with formulas like =VLOOKUP() or =IF(), avoiding macros entirely.

For simple text expansion (typing the same phrase), you can use Settings > Devices > Typing > Advanced Keyboard Settings—but Windows 10 doesn’t have a native text expander. Third-party tools like PhraseExpress fill that gap.

Frequently Asked Questions

Q: Where is the macro settings button in Windows 10?
There is no Windows-wide button. In Office, it’s under File > Options > Trust Center > Macro Settings. For other apps, look in their own settings or menus.

Q: How do I enable macros in Excel for a single file?
When you open a macro-enabled file (.xlsm), a yellow bar appears with an Enable Content button. Click it once. That enables macros for that file only, without changing global settings.

Q: Why can’t I record a macro in Excel on Windows 10?
You can, but only in the desktop version, not Excel for the web. Also, check that the workbook is not in compatibility mode (.xls). Save as .xlsm first.

Q: Are macros safe if I write them myself?
Yes, if you understand the code. But a typo can corrupt data. Always test on a copy of your file, and avoid using ActiveWorkbook.Save in loops that might overwrite.

Q: Can I use macros in Windows 10 without Office?
Yes. AutoHotkey and Power Automate Desktop work system-wide. They don’t use VBA, but they can automate keystrokes and mouse actions.

Q: How do I remove a macro from a Word document?
Open the file, press Alt+F11 to open VBA editor, find the module under Project Explorer, right-click and remove it. Then save as .docm or .docx (if you remove all macros, .docx is fine).

Related

Try it: the Column Letter to Number: aA is 27, XFD is 16,384. Converts both ways.

More in VBA & macros

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.