Fix macro have been disabled error in Excel super fast

Are you looking for a way to fix the macro have been disabled error in Excel? Stop here for a moment and TipsMake will explain in detail how to do it!

For Excel, Macro is an important and frequently used feature. This is a feature that helps automate repetitive tasks. Thanks to that, your work will be done faster and simpler. Therefore, it is annoying if Macro is disabled. Here is an effective way to fix the error macro has been disabled in Excel that you should apply.

Details on how to effectively fix the error macros have been disabled in Excel

Macro have been disabled means that Macro has been disabled. Don't worry too much because this is not an error. In fact, because Macro is related to executing commands, Excel will disable it by default to secure the document. Below are some tricks you should do to handle this problem.

Instructions for enabling Macros for a Workbook

When you open a workbook that contains Macros, a yellow security warning will appear indicating that macros are disabled by default. If you only want to enable macros for a single workbook in Excel, do the following:

1. Step 1 : In the open Excel page, you will see a yellow security warning appear at the top if that page has macros that are disabled. This warning will usually have the content ' Macros have been disabled ' or ' Some content has been disabled '.
2. Step 2 : To enable macros, click the 'Enable Content' button on the yellow security warning bar.

NOTE: In case the working file contains advanced features such as VBA code in Visual Basic Editor (VBE), Microsoft Excel Security Notice dialog box may appear. At this point, you need to confirm the trust again. If you trust the source and are sure that the Macro is safe, click Enable Macros to enable it. If you are not sure, you can click Disable Macros .

2/ Enable macros in Excel Backstage view

Another way to enable macros for a specific Excel file is to do it with Office Backstage view. In the open Excel file > Click the File tab on the toolbar > Select Info in the left menu > In the Security Warning section in the right frame > Click the arrow of the Enable Content button > Select Enable All Content . This action will also confirm that the Excel file is a trusted document.

IMPORTANT: In case you want to enable macros for a period of time and do not want to make this file a trusted document. You also go to File > Info > In the Security Warning box on the right, click Enable Content > Advanced Options > When the dialog box appears, tick Enable content for this session and click OK .

3/ Share how to enable macros for all Excel files via Trust Center

If you want to enable macros for all Excel files by default, follow these steps:

1. Step 1 : In the Excel file you are accessing, click the File tab > Select Options .
2. B2 : When the options window appears, click on Trust Center > Then click the Trust Center Settings… button in the right frame.
3. B3 : In the next window, click on Macro Settings on the left > Tick the Enable all macros option and click OK to save. Thus, all files from now on are considered trusted documents. However, you should consider when doing this because not all files received are trusted documents!

How to disable macros in Excel if needed

After instructing how to activate, the admin also shares how to disable all macros without receiving the usual warning. You also continue to access Trust Center Settings… (instructions B1 and B2 above).

Then, select Macro Settings in the list of options on the left > Tick the option Disable all macros without notification and click OK to save the changes to complete this process.

TipsMake has shared some solutions for you to fix the macro have been disabled error in Excel. Wish you guys apply it successfully!

1. Excel error handling trick: formula must be saved before jumping
2. Excel file opens to gray screen – Details on how to fix

David Pac

Update 17 January 2025