Skip to content
Back to template gallery
Microsoft Excel
Microsoft Excel

How to enable macros in Excel

This step-by-step guide shows you how to configure macro settings in Microsoft Excel to safely run automated tasks. You will navigate through Excel's Options menu to access the Trust Center and adjust your Macro Settings. By following these steps, you will enable VBA macros with notifications to ensure your workbooks function correctly while maintaining security.

Operations
9 steps 4 min Community template
1

Click Blank workbook

Click the Blank workbook option under the New section to start a new spreadsheet.

app.example.com
Click Blank workbook
2

Click the File button

Click the File button in the top-left corner of the ribbon to open the file menu.

app.example.com
Click the File button
3

Click the Options menu item

Click the Options menu item at the bottom of the left sidebar to open the settings panel.

app.example.com
Click the Options menu item
4

Select the Trust Center tab

Click the Trust Center option in the left sidebar of the Excel Options dialog.

app.example.com
Select the Trust Center tab
5

Click the Trust Center Settings button

Click the "Trust Center Settings..." button in the Excel Options dialog to configure your security and privacy preferences.

app.example.com
Click the Trust Center Settings button
6

Click the Macro Settings option

Click the "Macro Settings" option in the left sidebar of the Trust Center dialog box.

app.example.com
Click the Macro Settings option
7

Select "Disable VBA macros with notification

Click the "Disable VBA macros with notification" radio button in the Macro Settings section of the Trust Center.

app.example.com
Select "Disable VBA macros with notification
8

Click the OK button

Click the OK button at the bottom of the Trust Center dialog to save your settings.

app.example.com
Click the OK button
9

Click the OK button

Click the OK button at the bottom of the Excel Options dialog box to apply your changes.

app.example.com
Click the OK button

Make this walkthrough your own

Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.