How to Enable Macros on Excel

The following guide provides a clear overview of Excel, with the most relevant background, details, and practical takeaways.

How to Enable Macros in Excel 2013-2016

Here is what to do, if the above error message is displayed while opening the macro support file (XLS, XSLM, XLSB):

1. Click the File tab (top left tab in Excel window).

2. Click the Excel Options button.

3. Click Trust Center in the left menu.

4. Click Trust Center Settings in the right window.

5. In the new window, click Macro Settings in the left menu.

6. Select Enable all macros.

7. Click OK.

8. Click OK again.

9. Close all Office applications and restart Excel.

How to Enable Macros in Excel 2010

To enable macros in Excel 2010, follow these instructions:

1. Click the File tab (top left tab in the window).

2. Click the Excel Options button.

3. Click Trust Center in the left menu.

4. Click Trust Center Settings in the right window.

5. In the new window, click Macro Settings in the left menu.

6. Check the Enable all macros option (not recommended; potentially dangerous code can run).

How to Enable Macros in Excel 2007

Click the Office button (top left button in the window) and follow the same procedure as above.

Good luck!

• Create Macros in Excel 2007
• How to turn on / off Macro in Word
• Create and use automated macros in Word 2010