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
From the Excel 2010 window, first select the File tab.
This gets you to the Excel backstage.
From File choose Options, which could be found above the exit button.
From the Excel Options window choose Trust Center, which is usually the last button in the Left-Hand side list.
This gets you to the Trust Center Control Panel.
From there click the “Trust Center Settings” at the bottom, which will open another window.
Click on “Macro Settings” from the Left Hand side menu.
Now select the “Enable all macros” option, which comes as the last one.
Click OK twice, one on the Trust Center Window and another on the Excel Options Window . The Excel macros have been enabled.