WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Enable Macros in Excel

Enable Macros in Excel

How to Enable Macros in Excel (2007, 2010, 2013 & 2016)?

Enabling macros in excel is a process where we encounter an error while opening any macro-enabled worksheet because due to security reasons excel itself disables macros from the external sources, in order to enable macros we need to go to trust center in the options tab of files section and click on enable all macros which will enable all the macros in the workbook.

The first step is to check and decide what type of permission that is required to be given to the macros of excel. The decision can be to give partial permission, no permission, and even giving completed permission.

After the decision has been made regarding the permission type that should be granted we need to follow the below step.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course
  • Step 1: Click on the File Tab and go to the excel options.

enable macros in excel example 1.1

  • Step 2: From the options, go to the Trust Center Settings.

enable macros in excel example 1.2

  • Step 3: From the Macro settings, we have to choose what type of permission is required to be granted. If we want to give complete permission, as we trust the macros, then we can choose the option of “Enable all macros” in excel. If we need to stop the use of macros than we need to select “Disable all macros.”
  • Step 4: If we want a notification about the fact that the macros on this file have been disabled, then we need to select the option of “Disable all macros with notification,” and if we do not need a notification about the disabled macros than we need to select the option of “Disable without notification.”

trust center

  • Step 5: After selecting the appropriate type of permission, click on “OK” and that setting will be applied on your computer.
  • Step 6: To Enable macros in excel properly, we must also enable the ActiveX controls on excel. These ActiveX controls are necessary in case the macros Object requires ActiveX controls. From the “Trust center settings,” choose the option of Active X and select “enable all controls.”

trust center

How to Permanently Enable all Macro Files in Excel?

If we generally receive files from a trusted source and it contains some macro or VBA content, then we need to enable the macro feature to enable us to use the file. In this case, we can permanently enable the macros in excel, and this will hence save our time.

  • Step 1: Click on the File Tab of excel and go to the excel options.

enable macros in excel example 1.1

  • Step 2: From the options, go to the Trust Center settings > Trust Center settings.

Excel Options

  • Step 3: In Macro Settings, select Enable all macros.

Trust center

Things to Remember

  • The file that contains VBA code must be saved as a “Macro enabled file.” If the file is saved in another extension, then the VBA code will not be saved, and macros will not be enabled on the file.
  • If we have selected to “Enable all macros,” then all macros from a trusted or not trusted source will run without any warning or further consent. This may be dangerous sometimes.
  • If we have selected to “Stop macros without any notification,” then we might not be able to judge the fact why the macros that are in the file are not running at the first instance. So this is advised that we choose to show notification about the disabled macros.

Recommended Articles

This has been a guide to Enable Macros in Excel 2007, 2010, 2013 & 2016. Here we discuss how to enable macros in excel for different permission types along with examples. You may also look at these useful functions in excel –

  • Excel Dynamic Consolidate
  • Record Macros in Excel
  • Consolidate Data in Excel
  • VBA Macros
  • Drawing in Excel
67 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Login

Forgot Password?

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More