Here you are going to learn the way how you can enable or disable macros. In the below you can find all the information of enabling and disabling VBA or Excel Macros in Excel application.
In order to explain this concept we have written one small macro or VBA program in excel as shown in the below screenshot
Once we create a macro or VBA program in excel, usually we have to save excel file with Macro Enabled Workbook format. In order to save it we have to follow below steps
Click on Office button as shown in the below screen shot
Click on save button by giving your desired name to excel file in the above screen in your macro written excel file as shown in the below screen shot
Click on the save button. You have Excel Macro Enabled Workbook with you to enable or disable macros. Hence if you open the file as shown in the below screen shot you can file one alert ribbon in the excel file. We have two methods to use this macro enable or disable option in excel
Method 1: Always preferable method
Now click on above options button to see the macro enable option as shown in the below
Select the Enable this content option and click OK button to enable macro
This is one method of enabling macro in excel. And once you enable this option, and then only you can use the macro in excel.
Method 2: Not advisable except for exceptional cases
We have another method to enable macro in excel. In order to enable all macros without looking the above option, we have click on office button as shown in the first screen shot in this article and select excel options button. Once you click you can find the below screen and there you have select Trust Center option and you have to click that to see below screen shot related window in excel
Here in the above window you click on Trust Center Setting option to see below screen
In the above if you select “Enable all macros (not recommended; potentially dangerous code can run)” option and click OK button. But this second method is not advisable (except for exceptional requirements)