


Here, you’ll be able to see the four different macro security settings:ĭisable all macros without notification – If you select this option, all macros that aren’t in a designated trusted location are disabled. Step 3: Once in the Trust Center window, select Macro Settings from the list in the left panel of the window. Step 2: In the Excel Options window, select Trust Center from the list of categories in the left panel. Step 1: Click on the Office button in the upper left-hand corner of the Excel interface, and then click on Excel Options.

How to Change the Macro Security Settings To make changes to these settings, follow these steps. If you’ve recently received a shared workbook containing macros in Excel, you may be having trouble using it if your macro settings haven’t been adjusted.
