How to Enable Macros in Excel

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.

Ribbon

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

Enable macros

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

Remember! Watch out using macros from the internet.