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.
4.9 (1,353 ratings) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
- Step 1: Click on the File Tab and go to the excel options.
- Step 2: From the options, go to the Trust Center Settings.
- 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.”
- 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.”
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.
- Step 2: From the options, go to the Trust Center settings > Trust Center settings.
- Step 3: In Macro Settings, select Enable all macros.
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.
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 –