How To Enable Macros In Excel VBA

In this lesson you will learn how to enable macros in Excel 2010. This is useful trick because in Excel it is not so easy to find this option.What to do when somebody disabled macros in your spreadsheet?Go to Ribbon. Click File > Options.

Excel Ribbon File Options

Click Trust Center > Trust Center Settings.

Trust Center Options

From the left bar select Macro Settings.

Tick 4th option: Enable all macros. Actually this is not so dangerous… when you use spreadsheets from there source you trust.

Enable Macros Excel 2010



You can download the Template here – Download
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell