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 edit a macro that is attached to a Microsoft Excel workbook, you use the Visual Basic Editor. Important: Before you can work with macros, you have to enable the Developer tab. For more …

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 …

Suppose that every month, you create a report for your accounting manager. You want to format the names of the customers with overdue accounts in red, and also apply bold formatting. You …

Create a macro to run when Excel starts by using Auto_Open. For example, you might want workbooks that you use every day to open when you start Excel.

In Excel voert u een macro handmatig of automatisch uit. Een macro is een actie of een reeks acties die u kunt gebruiken om taken te automatiseren. In dit onderwerp worden verschillende …

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 …

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

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 …

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 …