How to Enable VBA Macros in Excel

Some templates and add-ins require VBA to be "enable" for them to work correctly.

Here you'll find step-by-step instructions as well as a short video on how to enable VBA macros in Excel so your macro enabled templates and add-ins will work correctly.

How to Enable VBA Macros in Excel

Watch the short video above or follow the step-by-step instructions below to enable VBA Macros in Excel.

1. Display Excel Options

In Excel, from the File menu select Options.

This will display the Excel Options dialog (screen).

2. Trust Center

From the left-side menu of the Excel Options dialog (screen) select Trust Center and then click Trust Center Settings...

3. Enable Macros

From the left-side menu of the Trust Center dialog (screen) select Macro Settings and then click Enable all macros.

Finally, click OK to accept this change.

You're done! Excel will now allow all workbooks with VBA macros to work without issue. 

What if I don't want to Enable all Macros?

You may not feel comfortable enabling all workbooks with VBA macros to run.

If that's the case, you can select a different option.

Instead, from Macro Settings and then click Disable all macros with notifation.

This means that when Excel opens a workbook with VBA macro it will disable them (prevent them from running).

Excel will then ask you if you would like to enable the VBA macros in this specific workbook only, like this:

If you trust the workbook - such as templates and add-ins from My Excel Genius - then click Enable Content.

If you do not trust the workbook or don't know where it came from, simply close the Security Warning.