EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Excel Enable Macros

Excel Enable Macros

Madhuri Thakur
Article byMadhuri Thakur

Updated August 11, 2023

Excel Enable Macros Example

Enable Macros in Excel

Macros in Excel are a series of commands that can use to record, automate and perform repetitive tasks as often as you want. Enable Macros in Excel; we often do the same tasks several times. We use the Excel macros function to simplify our tasks and save time. After creating Macros in Excel, we can edit and make minor changes to how 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 macros means any file can 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 the Macros setting dialog box in Excel?

  1. Enable macros in the Message Bar.
  2. Enable macros in Excel through the 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

  • First, we need to see whether the developer tab is added to use this particular method. If it is added, we can start directly from the developer tab.
  • If not, add the Developer tab in the ribbon and 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 the 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 the Developer Tab to the Excel ribbon.

Add Developer Tab Example 1-4

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

Macro Security 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 the Macro Settings section.

Excel Enable Macros Example 1-6

  • When an excel document is re-opened, which contains macros and Disabled all macros with the 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.

Enable content button Example 1-7

  • Thus the file becomes a trusted document, and the security warning message will disappear.
  • A security warning message will be displayed in case of Disabled macros.
  • Go to the File tab -> Click on Info to check the same. You will find Security Warning under Information about enabling macros in Excel on the right-hand side.
  • But if the file is enabled, no such option will appear under the 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 the 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 the 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 the 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 the Trust Center dialog box.

Macro Settings Example 2-3

  • The Macro Settings options are presented in the right panel with 2 sections: 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 the 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 the 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, exposing 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 are turned on. In this case, we can run macros-enabled files from locations trusted by Excel. This is possible as part of Excel 2007-2013.

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

In Excel, click go to File. Click on Options.

Excel Enable Macros Example 3-1

  • Excel Options dialog box appears. Click on the Trust Center option in the left panel of the 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 the Microsoft Excel Trust Center section.

Excel Enable Macros Example 3-2

  • Trust Center dialog box appears. Click on the Trust Locations option in the left panel of the Trust Center dialog box. The screen on the right panel of the 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 folders.

Trust Center Dialog Box 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 the Trusted Locations screen.

Conclusion

  • Macros function to automate and repeat complex activities as many times as require.
  • Enabling Macros in Excel can be done through a number of methods. Choose the one at your convenience.
  • The benefit of enabling Macros is that it exposes the computer to the possibility of running potentially malicious code that 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. Record Macro in Excel
  2. Examples of Excel Macros
  3. VBA Macros
  4. Excel Developer Tab
MICROSOFT POWER BI Course Bundle - 8 Courses in 1
34+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MS Excel & VBA for Data Science Course Bundle - 24 Courses in 1 | 10 Mock Tests
87+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
All-in-One Financial Analyst Masters Training Program Bundle - 550+ Courses | 300+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
All-in-One Data Science Bundle - 400+ Courses | 550+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Popular Course in this category
MS Excel Course Bundle - 36 Courses in 1 | 13 Mock Tests
 137+ Hours of HD Videos
36 Courses
13 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.9
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
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

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA

Download Enable Macros in Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*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

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Enable Macros in Excel Template

EDUCBA

डाउनलोड Enable Macros in Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more