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.

Microsoft Visual Basic for Applications (VBA) enables non-programmers to record, create, and edit macros that can automate tasks in Office applications. This article explains where you can …

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 …

Write macros. Run macros that you previously recorded. Use XML commands. Use ActiveX controls. Create applications to use with Microsoft 365 programs. Use form controls in …

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.

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 …

Note: To include Visual Basic for Application (VBA) functions for the Analysis ToolPak, you can load the Analysis ToolPak - VBA Add-in the same way that you load the Analysis ToolPak. In …

You create a macro in Excel by running the macro recorder or by using the Visual Basic for Applications (VBA) editor. After you've created your macro, you'll want to save it so you can …

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.