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.


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

Close and re-open Excel for the changes to take effect.

Note: Enabling all macros is not recommended as it can put your computer at risk of malware and viruses. It is better to enable only trusted macros that are signed by a trusted certificate.

It is also possible to enable macros for a single workbook. To do this, open the workbook and click on the "Enable Content" button that appears when the workbook opens.

Please keep in mind that enabling macros can make your computer vulnerable to malicious code. Be cautious when opening workbooks from untrusted sources or that contain macros. Always scan for viruses before enabling macros.