Improve security, evaluate and mitigate the risks of running macros, and see how to enable or disable macros for Microsoft 365.

Learn how to change the settings that enable or disable macros in Excel, and more. Change the macro security settings to control which macros run when you open a workbook.

Click Macro Settings, and then select the Enable Excel 4.0 macros when VBA macros are enabled check box. You can then select Disable VBA macros with notification or Enable all macros (not …

Macros and VBA tools can be found on the Developer tab, which is hidden by default, so the first step is to enable it. Go to Excel > Preferences… > Ribbon & Toolbar.

Macros and VBA tools can be found on the Developer tab, which is hidden by default, so the first step is to enable it. For more information, see Show the Developer tab.

In Excel, you run a macro manually or automatically. A macro is an action or a set of actions that you can use to automate tasks. This topic shows you several ways to run macros manually or automatically.

To be prompted each time a macro is detected, select Disable all macros with notification. This is the default setting. To silently disable all macros, select Disable all macros without notification. No …

On the Developer tab, in the Code group, click Macro Security. Under Macro Settings, click Enable all macros (not recommended, potentially dangerous code can run), and then click OK.

Macros and VBA tools can be found on the Developer tab, which is hidden by default, so the first step is to enable it. For more information, see Show the Developer tab.

Although you can't create, run, or edit VBA (Visual Basic for Applications) macros in Excel for the web, you can open and edit a workbook that contains macros. Any existing macros will remain in the …