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.
Click Trust Center > Trust Center Settings.
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.