How To Enable Macro In Excel

0
How to enable macro in excel
How to enable macro in excel

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

How to enable macro in excel - Create Macro Example
How to enable macro in excel – Create Macro Example

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

How to enable macro in excel - Click on office button
How to enable macro in excel – Click on office button

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

How to enable macro in excel - Click on Save button
How to enable macro in excel – Click on Save button

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

How to enable macro in excel – Security warning label with option button

Now click on above options button to see the macro enable option as shown in the below

How to enable macro in excel - Click on Enable this Content Option To Enable Macro
How to enable macro in excel – Click on Enable this Content Option To Enable Macro

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

How to enable macro in excel - Click on Excel Options Button
How to enable macro in excel – Click on Excel Options Button

Here in the above window you click on Trust Center Setting option to see below screen

How to enable macro in excel - Click on Enable all macros option
How to enable macro in excel – Click on Enable all macros option

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)

 

 

 

 

 

 

LEAVE A REPLY

Please enter your comment!
Please enter your name here