Table Of Contents
How To Enable Macros in Excel (2007, 2010, 2013, and 2016)?
VBA codes are very helpful in automating complex tasks which should be run manually. However, they can pose significant risks from a security point of view. There are macros which can delete your files, damage the hard drive and corrupt your data. Hence, it is important that one enables only safe macros that have been written or recorded yourself or are from trusted sources. Hence, Excel's default setting is that it disables all macros and provides a notification. One should exercise caution before they decide to enable macros in Excel.
At the foremost, the user should decide the extent of permission to be given while enabling macros. The consent can be partial, complete or zero (no permission).
Once decided on the extent of permission, follow the steps listed below to enable Excel macros:
Step 1: In the File tab, click āOptions.ā
Step 2: In the āExcel Optionsā dialog box, click āTrust Center Settingsā in the āTrust Centerā option.
- Step 3: How to change macro settings in Excel
From the āMacro Settings,ā select the extent of permission to be granted. Depending on the requirement, the user can choose one of the following options (shown in the succeeding image):
⢠āDisable all macros without notificationā does not send any notifications regarding the disabled macros.
⢠āDisable all macros with notificationā sends notifications stating that macros of the current file are disabled.
⢠āDisable all macros except digitally signed macrosā stops the usage of all macros except the digitally signed ones.
⢠āEnable all macrosā gives full permission to run all macros.
Click āOkā to apply the selected macro settings.
Note: The option āenable all macrosā is selected only if the source is trusted.
- Step 4: In the āActiveX settingsā option (under āTrust Center Settingsā), select āenable all controls without restrictions and without prompting.ā
The ActiveX controls are activated to enable macros properly. These controls are necessary for the object of macros.
Key Takeaways
- Macros in Excel are written in VBA to perform repetitive tasks quickly.
- Excel disables macros by default to protect against harmful code like viruses.
- To enable macros, go to File ā Options ā Trust Center ā Trust Center Settings ā Macro Settings.
- Now, choose: "Enable all macros" or "Disable all macros with notification" (recommended for safety).
How To Enable all Macro Files in Excel Permanently?
If a file received from a trusted source contains macros or VBA content, the macros need to be enabled if we have to use the file. In such cases, the macros are enabled permanently to save time.
The steps to enable macros in Excel permanently are listed as follows:
Step 1: In the File tab, click āOptions.ā
Step 2: In the āExcel optionsā dialog box, click āTrust Center Settingsā in the āTrust Centerā option.
Step 3: In the āmacro settingsā option, select āenable all macros.ā Click āOkā to apply the selected macro settings.
Now, you have permanently enabled macros in Excel.
The Cautions While Enabling Macros
The following points must be remembered while enabling macros:
- The file containing VBA code must be saved as āmacro-enabled workbook.ā Saving the file with some other extension does not save the VBA code and thus, does not enable the macros.
- The option āenable all macrosā runs all macros without any further warning or consent. Since the macros of both trusted and non-trusted sources are enabled, it might become dangerous.
- The option ādisable all macros without any notificationā does not inform the reason behind why macros are not running. Hence, select ādisable all macros with notificationā to view the warnings.
Interested in learning more on Macros? You can check out our Basic Excel VBA Macro Crash Course for Beginners which will be very helpful in sharpening your skills.