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.

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.

To make your macros available every time you open Excel, you can create them in a workbook called Personal.xlsb. That’s a hidden workbook stored on your computer, which opens in the …

In Word, you can automate frequently used tasks by creating and running macros. A macro is a series of commands and instructions that you group together as a single command to …

Microsoft Office works with Windows 10 S to help keep you safer by blocking macros in files from untrusted sources. This article explains the feature in more detail and tells you how you can …

For information about the security risks of macros and enabling or disabling macros in documents in the Trust Center, see Enable or disable macros in Office documents.

To help prevent macros that contain viruses from contaminating your system, by default Office for Mac displays a warning message whenever you try to open a document that contains a macro.

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 …