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 …

To automate a repetitive task, you can record a macro with the Macro Recorder in Microsoft Excel. Imagine you have dates in random formats and you want to apply a single format to all …

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

To save time on tasks you do often, bundle the steps into a macro. First, you record the macro. Then, you can run the macro by clicking a button on the Quick Access Toolbar or pressing a …

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.

If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks. A macro is an action or a set of actions that you can run as many times as you …

By single stepping through a macro, you can observe the flow of the macro and the results of each action, and isolate any action that causes an error or produces unwanted results.

In the sections below, learn how to add a macro to a button in Excel—for Windows or the Mac. Note: ActiveX controls are not supported on the Mac.

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 …

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 …