In Microsoft Excel, macros play an essential role as they help you perform certain tasks. If you are thinking about how to enable macros in Excel 2016 and older versions, stick to this guide till the end to get your answers.
Users find macros helpful to use as they can form defined functions and programs designed to perform specific tasks. However, if you run a malicious macro unknowingly then it could harm or corrupt the Microsoft Office and come up with a sort of problem. This is why Microsoft keeps the untrusted macros disabled by default. If you want to learn how to enable macros in Excel 2013 or other versions then you are going to find this guide helpful.
In this particular guide, you will discover different ways to enable macro and run it in Excel. These different ways cover the following versions of Microsoft Excel along with a manual procedure.
- How to Enable Macros in Excel 2016?
- How to Enable Macros in Excel 2013?
- How to Enable Macros in Excel 2010?
- How to Enable Macros in MS Excel 2007?
- How do you Enable Macros in Excel 2003?
How Do I Enable Macros in Excel?
To enable macros in Excel 2003 or other versions, you can use different methods such as enabling macros using Message bar, through Macro settings with Trust Center. Besides that, you can easily run macros when the settings are disabled. These steps can be performed on Windows or Mac computers. So, if you are thinking about how to enable macros in Excel Mac 2016 or other versions or how to enable macros in Excel 2007 in Windows 7 then read this guide to end your research. Let us understand these methods based on the Microsoft Excel version you use currently.
How to Enable Macros in Excel 2016, 2013, 2010?
If you use Microsoft Excel 2010, 2013, 2016 and you see an error message that the macros have been disabled because of the security settings then you can re-enable it. To do so, you can go through the steps instructed below on how to enable macros in Excel 2013, 2016, 2010.
- To get started, open the Excel and click on the File option located on the top left.
- Then, you can go to the Excel Options button.
- Here, you can choose the Trust Center option located on the left.
- Right after that, you are required to select Trust Center Settings located on the right.
- When a new window opens, you can click on the Macro Settings option located on the left.
- Here, you can select the Enable all macros option.
- After clicking on the OK button, you can close all the Office applications and launch Excel again.
If you were looking for a quick solution on how to enable macros in Excel 2010, 2013, or 2016, the above-mentioned steps are easy to perform. This will allow you to enable the disabled macros in Excel.
How to Enable Macros in MS Excel 2007?
If you are a user of MS Excel 2007 and you are annoyed with disabled macros in Excel then do not worry. Here are the following steps on how to enable macros in MS Excel 2007:
- To begin, you need to open your Excel file and go to the Office option.
- Next to this, you can click on the Excel Options located at the bottom.
- At this point, you are required to choose the Trust Center option.
- Thereafter, you can select the Trust Center Settings.
- Under the Trust Center Settings, you will find Macro Settings. Here, you can enable the macro.
- Right from here, you can also select the security level to run the macros in Excel.
If you were struck by this question how can I enable macros in Excel 2007, the above-mentioned steps will solve your questions in a minute.
How Do You Enable Macros in Excel 2003?
Most of the users prefer to use the older version of Microsoft Excel. If you are the one who uses Excel 2003 or 2000 then these upcoming steps are for you. If somebody asks you how do you enable macros in Excel 2003 or 2000, let them know about the following instructions:
- In MS Excel, you need to go to the Tools tab.
- Next to this, you can select the Macro option.
- After this, you need to click on the Security option.
- Once you do so, a new window opens that shows all security levels that can be selected by you for macros.
- Here, you can select the Medium Security option, and this will prompt permission whenever you run macro in Excel.
Macro Settings Detailed Explanation for Excel 2016 and Other Versions
Before you think about how do I enable macros in Excel, know the detailed explanation on settings for the macro in Excel. As mentioned earlier, MS users prefer to use different kinds of versions as per their convenience. For MS Excel 2016, 2013, 2010, 2007, and 2003, security options can be different. Hence, below is the explanation for macro settings.
- Disable all macros without notification: Selecting this setting for macro will make all the macros inactive. In addition, it will not bother you with notifications.
- Disable all macros with notification: After going with this macro setting, you will disable all the macros in Excel but you will be receiving notifications. In other words, whenever you open the Excel sheet, you will have the notification saying if you wish to run the macro.
- Disable all macros except digitally signed macros: This setting is quite similar to the second setting mentioned above. The only difference in this is it will allow the macros to run if it is from the trusted publishers.
- Enable all macros (not recommended; potentially dangerous code can run): However, this setting is not recommended because if you choose this setting, any macros will be enabled with no warning at all. As a result, it can harm your Excel.
- Trust access to the VBA project object model: In this setting, it allows macros to get modified in open Workbooks. However, external analytics programs might require you to activate this but you can leave it unchecked.
Conclusion
By default, macros are inactive in Microsoft Excel and Microsoft Office applications. Luckily, you can re-enable it to create programs and perform certain tasks. Enabling macro in Excel is easy. All it is required to know your Microsoft Excel version and apply settings based on the current version. If you have been willing to know how to enable macros in Excel 2016 or other versions then the aforementioned ways would have helped you for sure.
Along with the process of enabling macros, we have covered a detailed explanation about macro settings. It will help you to understand each action you apply in macro settings.
In case you are looking for an easy guide on how to group rows in Excel with expand collapse, read here. Besides that, you can learn easy ways to delete comments in Excel.