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.

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 …

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 …

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 …

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 …

To automate a repetitive task so that you can do the task again with a single click, you can use the Developer tab in Excel for Mac to record and run a macro. You can also create a macro by …

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. …

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 want.

Change ActiveX-control settings in Word, Access, Excel, PowerPoint, Publisher, and Visio Use the following instructions to enable or disable ActiveX controls in the Trust Center.