Ever stuck with the security warning message bar in Excel? Looking for the fixes to disable security warnings in Excel? Well to learn how to perform this task check out the complete post.

What is Security Warning Message Bar In Microsoft Excel?

In my post I will discuss about three most commonly encountered security warning message bar.
• When your Excel file opens in read-only mode and you need to edit it. For removing such security warning message bar, you need tap on the enable editing option.
• While trying to open Excel workbook having macros. At that time, you will encounter security warning like “macros have been disabled”.
• when your Excel spreadsheet is stuffed with some potentially unsafe active content. This time the application will throw error message “the file originated from an internet location and might be unsafe”.

All these errors appear within a yellow message box, along with the shield icon. All these three aforementioned warning messages are just to alert use about potential problems.

Let’s discuss how to troubleshoot security warning messages in Excel but one by one.

Steps To Solve “ActiveX Controls Has Been Disabled” Security Warning In Excel

To fix Excel security message “ActiveX control has been disabled” error try the following fixes:

Enable ActiveX Controls In The Backstage View

For enabling the ActiveX controls in Excel file using the MS Office Backstage view.

• Tap to the File tab on your Excel application.
• Now in Security Warning message area, tap to the Enable Content option.

• Under Enable All Content, hit on the Always enable this document’s active content.

After making such changes your file is after then counted as trusted one. So, you won’t get “ActiveX control has been disabled” error anymore.

Steps To Fix “Macro Has Been Disabled” Security Warning In Excel

To fix “Macro Has Been Disabled” security warning in Excel you need to change macro settings in the trust center.
Follow the below steps to perform Change macro settings in the Trust Center

Change macro settings in the Trust Center

If you are attempting this Changing macro settings from trust center then let me clear this to you that. This step is only applicable for currently using office version not for office programs.

• Hit on the File
• Tap to the Options.
• Tap to the Trust Center, and then hit on the Trust Center Settings option.
• Now in the Trust Center open window, choose the Macro Settings from the left sidebar.
• In the opened window you will get the 4 option so choose anyone from it. To know about each of these option, read out the following info:

• Disable all macros without notification:
If you choose this option then it will disable the macros and security alerts regarding macros.
• Disable all macros with notification:
If you choose this option then it will disable only macros not the security alerts.

• Disable all macros except digitally signed macros
In this option also, macro is only disabled but not the security alerts. But in this option macro present in your Excel workbook will only if it is digitally signed by trusted publisher. Or else the user will start getting notification to enable the trust publisher and signed macro.

• Enable all macros (not recommended, potentially dangerous code can run):
By choosing this option you are allowing all macros to run. But be careful because by choosing this option setting your PC will be more vulnerable to potentially unsafe code.

• After making selection from any of these four-option tap to the OK option.

How To Fix “Protected View” In MS Excel

To disable “protected view” security warning message in Excel try the following steps:

Steps To Disable Protected View

• Firstly, you need to open the Excel application. After that choose the “File” menu option.
• Hit the “Options” tab.
• Choose the “Trust Center” option and hit the “Trust Center Settings”
• In the opened trust center window, choose the “Protected View” from the left sidebar.
• Here you will get the 5 check boxes, so read them carefully. And un-select the undesired option.

After performing this step, now you won’t strike by any Excel file “Protected View” security warning.

How Enable Or Disable Security Alerts For All MS Office Applications

If you want to do one such setting which is applicable to all MS office application. Then also you have the option. Here is the following step that you need to perform:

1. Go to your Office program, hit the File option
2. Hit the Options.
3. Choose the Trust Center. In the opened window you will get the option Trust Center Settings. So, tap on it.
4. In the opened window hit the Message Bar option from the left sidebar. After tapping to this option, you will see a dialogue box having “Message Bar Settings for all Office Applications”. This dialogue box window contains two options:

• Show the Message Bar in all applications when document content is blocked

First option is the default option. Choosing to this option will starts showing the security warning Message bar when document content is disabled.

• Never show information about blocked content

Choosing the second option will disable the security warning Message Bar. After selecting this option no warning message regarding security alerts will come in the excel spreadsheet.

Conclusion:

After reading the above post, I hope you can now solve these annoying Excel Security Warnings on your own.