Disable Security Alerts (Never Show Information about Blocked Content)

This post will guide you how to enable or disable security alerts on the message bar in excel. How do I disable Alert warning messages in excel. How to turn off security alerts and policy tips in the message bar in excel 2013/2016. How to never show information about blocked content in excel.

Disable Security Alerts

You should know that the message bar used to show security alerts when there is unsafe active content, such as: macros, ActiveX controls, data connections and so on. The message bar appears yellow or read with a shield icon to alert you about potential problems. If you do not see this kind of security alert messages again, how to turn off the message bar? Let’s follow these steps:

#1 go to FILE tab, click Options button. The Excel Options dialog will appear.

disable security alerts1

#2 click Trust Center tab, and then click Trust Center Settings button. The Trust Center dialog will appear.

disable security alerts2

#3 click Message Bar tab, check Never show information about blocked content option.

disable security alerts3

Note: if this option is selected, and the message bar does not appear and no alerts appear about security issues, regardless of any security settings in the Trust center.

#4 click OK button.


Related Posts

Excel/Google Sheets: Full Row Reference

Excel or Google sheets supports both full row references and full column references. This article will talk about the usage of full row references. Full Row reference is another cell reference in Excel or Google Sheets, which is used to ...

Excel/Google Sheets: Full Column Reference

Full column reference is another cell reference in Excel or Google Sheets, which is used to reference the entire column, for example, if you want to reference the entire column A, you can use the following reference format A: A. ...

Excel/Google Sheets: Expanding Reference

An expanding reference is a reference type in Excel and Google worksheets that extends the range of a cell when a formula is copied to the cell below or to the right. In this article, we will explain how to ...

Excel/Google Sheets: Mixed Reference

In Microsoft Excel Spreadsheet or Google sheets, there is another cell reference, mixed references, where part of the reference is absolute, part of the relative. This article will describe how to use mixed references through specific examples. Mixed Reference When ...

Excel/Google Sheets: Absolute Reference

In Microsoft Excel spreadsheet or Google Sheets, the cell reference is the cell or cell area address or name in the worksheet, the cell reference contains two types of references, namely, relative references and absolute references. Absolute Reference An absolute ...