How to enable macros on Excel

The following article will guide you how to enable macros in Excel 2007, 2010, 2013 and 2016.

How to enable macros in Excel 2013-2016

How to enable macros on Excel Picture 1

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 on Excel Picture 2

How to enable macros in Excel 2010

How to enable macros on Excel Picture 3

To enable macros in Excel 2010, follow these instructions:

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

How to enable macros on Excel Picture 4

2. Click the Excel Options button .

How to enable macros on Excel Picture 5

3. Click Trust Center in the left menu.

How to enable macros on Excel Picture 6

4. Click Trust Center Settings in the right window.

How to enable macros on Excel Picture 7

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

How to enable macros on Excel Picture 8

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

How to enable macros on Excel Picture 9

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!

See more:

1. Create Macros in Excel 2007
2. How to turn on / off Macro in Word
3. Create and use automated macros in Word 2010