Trust Center Macro Settings

Microsoft Office security and privacy settings are located in the Trust Center . The Macro Settings tab of the Trust Center contains the macro security settings for your computer. Macro security is important to protect your computer against the threat of malicious code that can be inserted in Microsoft Office macros.

You can access the Macro Settings in the Trust Center in the following ways:

• On the Developer tab, in the Code group, click the Macro Security button. This will open the Macro Settings pane of the Trust Center dialog box. 
• On the Ribbon, click the File tab and then click Options > Trust Center > Trust Centre Settings > Macro Settings .

By default, Excel 2019 disables all macros from external sources with a security alert on the message bar, giving you the option to enable the macro or ignore it. This is the default setting when you install Excel, but there are other security options from which you can choose.

You can also select one of these options in Macro Settings:

• Disable all macros without notification : This automatically disables macros in your computer. This setting means no macros will run on your computer and you’ll not get a security alert giving you the option to run the macro. This option is useful for shared computers, for example, where you don’t want anyone using the computer to run macros.
• Disable all macros with notification : This option is the default. All macros from external sources are disabled with a security alert showing on the message bar. With this option, you have to specifically choose to enable the macro before it can run.
• Disable all macros except digitally signed macros : This option disables all macros apart from the digitally signed macros from publishers that you have added to your Trusted Publishers in the Trust Center. When you have this option selected and you get a macro from a publisher that’s not in your Trusted Publishers list, you will get an alert in the message bar with a Trust All Documents from this Publisher button that you can click to add them to the to your trusted publishers.
• Enable all macros (not recommended; potentially dangerous code can run) : This option enables all macros without any notifications or security alerts, even those macros that are not digitally signed or authenticated. As stated in its label, this option is not recommended because you can inadvertently run malicious code that corrupts your data or damages your computer.