• Skip to primary navigation
  • Skip to content
  • Skip to primary sidebar
  • Skip to footer
EDUCBA

EDUCBA

MENUMENU
  • Resources
        • Excel Charts

          • Histogram Chart Excel
          • Basic Excel Formulas
          • Text to Columns in Excel
        • Excel Charts
        • Excel Tips

          • Excel Gantt Chart
          • IFERROR with VLOOKUP
          • Data Table in Excel
        • Excel Tips
        • Excel Tools in Excel

          • Stacked Column Chart
          • Cheat Sheet of Excel Formulas
          • Excel Data Validation
        • Histogram chart in excel
        • Others

          • Resources (A-Z)
          • Excel Functions
          • Financial Functions in Excel
          • Logical Functions in Excel
          • Lookup Reference Functions in Excel
          • Maths Function in Excel
          • TEXT and String Functions in Excel
          • View All
  • Free Courses
  • All Courses
        • Certification Courses

          Excel Course 1
        • All in One Bundle

          All-in-One-Excel-VBA-Bundle
        • Excel course

          Excel-Training
        • Others

          • Excel advanced course
          • VBA Course
          • Excel Data Analysis Course
          • Excel for Marketing Course
          • Excel for Finance Course
          • View All
  • 120+ Courses All in One Bundle
  • Login

Excel Enable Macros

Home » Excel » Blog » Excel Tools » Excel Enable Macros

Excel Enable Macros Example

Excel Enable Macros (Table of Contents)

  • Enable Macros in Excel
  • How to open and run Macro setting dialog box in Excel?
    • Enable macros in the Message bar
    • Enable macros in Excel through Macro setting under the Trust Center
    • Even if all macros are disabled

Enable Macros in Excel

In MS-Excel we often do the same tasks a number of times. In order to make our task easy and to save our time, we use macros function in Excel. Macros in Excel is a series of commands that can be used to record, automate and perform the repetitive tasks as many times as you want. After creating Macros in Excel, we can edit and make minor changes to the way it works.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Excel Enable Macros Example 1-1

What is Enabling of Macros in Excel? Excel

Enabling of macros means any file will be able to run macros codes on your computer, which is potentially dangerous from the security point of view depending on the security levels set in your program and computers.

How to open and run Macros setting dialog box in Excel?

  1. Enable macros in the Message bar.
  2. Enable macros in Excel through Macros setting under the Trust center.
  3. Even if all macros are disabled.

Let us elaborate and understand the above points.

You can download this Enable Macros in Excel Template here – Enable Macros in Excel Template

1. Enable macros in the Message bar

  • To use this particular method, first, we need to see whether the developer tab is added. If it is added then we can directly start from the developer tab.
  • If not, then first add Developer tab in the ribbon and then start.
  • Go to the File tab-> Click on Options

Excel Enable Macros Example 1-2

Or

  • Right click the mouse, anywhere in the ribbon.

Excel Enable Macros Example 1-3

  • A pop-up list will appear. From the pop-up list choose Customize Ribbon
  • Excel Options dialog box will appear. Click on the Customize Ribbon in the left panel menu of Excel Options dialog box.
  • On the right-hand side of the panel, Customize ribbon screen Click on Developer under Main tabs, Click OK button. This will add Developer Tab in the Excel ribbon.

Excel Enable Macros Example 1-4

  • Click on Developer Tab-> Go to the Macro Security option under code group.

Excel Enable Macros Example 1-5

  • Trust center screen will appear. Click on the Macro Settings in the left panel. To enable macros, select the radio button corresponding to Enable all macros (not recommended; potentially dangerous code can run) option under Macro Settings section.

Excel Enable Macros Example 1-6

  • When excel document is re-opened which contains macros and Disabled all macros with notification is selected, a yellow Message Bar with a shield icon and Enable content button appears on top of the excel sheet.
  • Press Enable content button where the macros are from trustworthy sources.

Excel Enable Macros Example 1-7

  • Thus the file becomes a trusted document and security warning message will disappear.
  • A security Warning message will be displayed in case of Disabled macros.
  • To check the same go to File tab -> Click on Info. On the right-hand side, will find Security Warning under Information about enable macros in Excel
  • But if the file is enabled, no such option will appear under Info option.

Disabled macros in Excel:

Excel Enable Macros Example 1-8

Enabled macros in Excel:

Excel Enable Macros Example 1-9

2. Enable Macros in Excel through Macros Settings under Trust center

Steps to follow if Macros Settings are not working:

By default, macros remain disabled in MS Excel. To enable macros in Excel, please refer to the following steps:

  • Go to the File menu in Excel ribbon. In the backstage view under Help click on Options -> the Excel Options dialog box will appear.

Excel Enable Macros Example 2-1

  • Click on the Trust Center in the left panel menu of Excel Options dialog box.
  • The Trust Center screen appears in the right panel of the Excel Options dialog box.
  • Click on Trust Centre Settings…

Excel Enable Macros Example 2-2

  • The Trust Center dialog box will appear
  • Click on the Macro Settings in the left panel of Trust Center dialog box.

Excel Enable Macros Example 2-3

  • The Macro Settings options are presented in the right panel with 2 sections, namely, Macro Settings and Developer Macros Settings.
  • Under the Macro Settings section, Disable all macros with notification radio button remains selected by default.
  • The checkbox corresponding to Trust access to the VBA object model under Developer Macros Settings section remains deselected by default.
  • To Enable macros, select the radio button corresponding to Enable all macros (not recommended; potentially dangerous code can run) option under Macros Settings section. Also, select the checkbox corresponding to Trust access to the VBA object model under Developer Macros Settings.

Excel Enable Macros Example 2-4

The above settings will enable macros by default in Excel, however, It will expose the computer to vulnerabilities.

3. How to run macros when all macros settings are disabled?

 It is possible to run macros even when Disable all macros without notification is turned on. This is possible as part of Excel 2007-2013. In this case, we can run macros-enabled files from locations trusted by Excel.

Following are the steps to be followed for adding locations to the trusted zone.

Popular Course in this category
Cyber Week Sale
Excel Advanced Training (14 Courses, 21+ Projects) 14 Online Courses | 21 Hands-on Projects | 129+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.8 (2,665 ratings)
Course Price

View Course

Related Courses
Excel Training (18 Courses, 9+ Projects)

In Excel click go to File. Click on Options.

Excel Enable Macros Example 3-1

  • Excel Options dialog box appears. Click on Trust Center option in the left panel of Excel Options dialog box.
  • The screen on the right panel of the Excel Options dialog box shows the Trust Center screen. Click on Trust Center Settings… button under Microsoft Excel Trust Center section.

Excel Enable Macros Example 3-2

  • Trust Center dialog box appears. Click on Trust Locations option in the left panel of Trust Center dialog box. The screen on the right panel of Trust Center dialog box shows the Trust Locations screen. In Trust Locations, the list of trusted locations is seen. You may add new locations or folder.

Excel Enable Macros Example 3-3

Following are trusted locations, by default for macros to run from.

  • Program Files (x86)\Microsoft Office\Templates\
  • AppData\Roaming\Microsoft\Excel\XLSTART\
  • Program Files (x86)\Microsoft Office\Office14\XLSTART\
  • AppData\Roaming\Microsoft\Templates\
  • Program Files (x86)\Microsoft Office\Office14\STARTUP\
  • C:\Program Files (x86)\Microsoft Office\Office14\Library\

One can Add, Remove or Modify trusted locations from Trusted Locations screen.

Conclusion

  • Macros is used to make the repetitive complicated task easy and as many times as required.
  • Enabling Macros in Excel can be done through the number of methods. Choose the one as per your convenience.
  • The benefit of enabling Macros is that it exposes the computer to the possibility of running potential malicious code which may reside inside the macros.

Recommended Articles

This has been a guide to Enable Macros in Excel. Here we discussed how to Enable and Disable Macros in Excel through different methods along with practical examples and downloadable excel template. You can also go through our other suggested articles –

  1. How to Record Macro in Excel?
  2. Enable VBA Function in Excel
  3. How to Unmerge Cells in Excel?
  4. How to Protect Excel Workbook?

All in One Excel VBA Bundle (120+ Courses, 30+ Projects)

120+ Online Courses

30+ Projects

500+ Hours

Verifiable Certificates

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar
Excel Functions Tutorials
  • Excel Tools
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (10+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (12+)
  • Lookup Reference Functions in Excel (30+)
  • Maths Function in Excel (39+)
  • TEXT and String Functions in Excel (25+)
  • Date and Time Function in Excel (20+)
  • Statistical Functions in Excel (55+)
  • Information Functions in Excel (4+)
  • Excel Charts (44+)
  • Excel Tips (195+)
  • VBA (180+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (14+)
  • Excel Formula and Functions (20+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE
Footer
About Us
  • Who is EDUCBA?
  • Sign Up
  •  
Free Courses
  • Free Online Excel Course
  • Free Vba Course
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training
Resources
  • Resources (A To Z)
  • Excel Charts
  • Excel Tips
  • Excel Tools in Excel
  • Excel Functions
  • Financial Functions in Excel
  • Logical Functions in Excel
  • Lookup Reference Functions in Excel
  • Maths Function in Excel
  • TEXT and String Functions in Excel
  • Date and Time Function in Excel
  • Statistical Functions in Excel
  • Information Functions in Excel
Apps
  • iPhone & iPad
  • Android
Support
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions

© 2019 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

Download Enable Macros in Excel Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

Let’s Get Started
Please provide your Email ID
Email ID is incorrect

Limited Period Offer - All in One Excel VBA Bundle (120+ Courses, 500+ hours of Videos) View More

Limited Period Offer - Limited Period Offer - All in One Excel VBA Bundle (120+ Courses, 500+ hours of Videos) View More