HOW TO: Enable Macros in Excel

HOW TO: Enable Macros in Excel

Squeezing out Excel’s potential is never over unless one spends some time in the Visual Basic IDE. Though doing this backstage coding seems easy, for an experienced developer letting the end user use those macros could get a hell lot complicated with Excel blocking off the macros, terming them as potential threats. This step by stem tutorial could get even a 5 yr. old enable macros in a jiffy.

 

No. of Steps: 7

Difficulty level: Very Easy

 

Single line HOW TO for Pros:

File tab—>Options—>Trust Center—> Trust Center Settings –>  Macro Settings –> Enable all macros—> OK—> OK

 

Step 1:

From the Excel 2010 window, first select the File tab.

image

This gets you to the Excel backstage.

image

Step 2:

From File choose Options, which could be found above the exit button.

image

 

Step 3:

From the Excel Options window choose Trust Center, which is usually the last button in the Left-Hand side list.

image

image

This gets you to the Trust Center Control Panel.

 

Step 4:

From there click the “Trust Center Settings” at the bottom, which will open another window.

image

image

 

Step 5:

Click on “Macro Settings” from the Left Hand side menu.

image

 

Step 6:

Now select the “Enable all macros” option, which comes as the last one.

image

 

Step 7:

Click OK twice, one on the Trust Center Window and another on the Excel Options Window . The Excel macros have been enabled.

image