How to enable and disable macros in Excel | Excel macro settings Enable macros via security warning

Описание

How to enable macros for individual workbooks
There are two ways to turn on macros for a certain file: directly from the workbook and through the Backstage view.

Enable macros via security warning bar
With the default macro settings, when you first open a workbook containing macros, the yellow security warning bar appears at the top of the sheet right under the ribbon:
Enabling macros via security warning bar

If the Visual Basic Editor is open at the time you are opening the file with macros, the Microsoft Excel Security Notice will be displayed:
Microsoft Excel Security Notice

If you trust the source of the file and know that all the macros are secure, click the Enable Content or Enable Macros button. This will turn on the macros and make the file a trusted document. The next time you open the workbook, the security warning won't appear.

If the source of the file is unknown and you don't want to enable macros, you can click the 'X' button to close the security warning. The warning will disappear, but macros will remain disabled. Any attempt to run a macro will result in the following message.
A warning that macros have been disabled.

If you've disabled macros accidentally, simply re-open the workbook, and then click the Enable Content button on the warning bar.

Turn on macros in Backstage view
Another way to enable macros for a specific workbook is via the Office Backstage view. Here's how: