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

Remember! Watch out using macros from the internet.