• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Enable Macros in Excel

April 9, 2021 by Andrew Childress
How to enable Excel macros

Macros help you automate repetitive tasks in Excel. Let's learn how to enable macros in Microsoft Excel with these helpful steps.

Macros help you automate repetitive tasks in Excel. But you’ll notice that they aren’t enabled by default. Let’s learn how to enable macros in Microsoft Excel.

How to Enable Macros in Excel

Macros can pose a security risk, so Excel won’t automatically enable them unless to tell it otherwise.

Imagine you’ve received a file, and you need to run the macros inside it. If they’re not already running, chances are your Excel installation isn’t set up to notify you about these macros.

From the menu bar left of File, click on the Excel menu dropdown. Then, click Preferences.

How to enable Excel macros

You’ll see an array of options here. The one you want can be found under the Security tab. Go ahead and click there.

Enable macros in Excel

Below, you’ll see the Macro Security section. There are three options. By default, notice that Disable all macros without notification is checked. The option you want to use is the middle: Disable all macros with notification.

Enable Excel macros

Go ahead and click on the bubble to activate this option. The last (Enable all macros) is available, but can be very risky. Macros created poorly – or with malicious intent – can damage or destroy your data, or even your computer’s operating system.

Once you’ve activated Disable all macros with notification, you can open Excel files with macros inside. You’ll get a popup notification each time you open a file, asking whether you want to disable or enable the macros.

This technique lets you enjoy the benefits of macros, without taking on unnecessary risks from opening them automatically.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:#ref! in Excel#REF! in Excel
Next Post:Subtotal in ExcelColumn subtotals in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top