Enable or disable macros in Microsoft 365 files
Improve security, evaluate and mitigate the risks of running macros, and see how to enable or disable macros for Microsoft 365.
Change macro security settings in Excel - Microsoft Support
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.
Create or run a macro - Microsoft Support
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 accomplish a task automatically.
Enable or disable macros in Office for Mac - Microsoft Support
Enable or disable macros in Office for Mac. Applies To. 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.
Quick start: Create a macro - Microsoft Support
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. When you create a macro, you are recording your mouse clicks and keystrokes.
How do I create macros? - Microsoft Support
Using the mouse that you want to configure, start Microsoft Mouse and Keyboard Center. In the list under the button that you want to reassign, select Macro. From the Available Macros list, select the macro you want to edit. Click in Editor and edit the macro or enter new events.
Automate tasks with the Macro Recorder - Microsoft Support
Enable or disable macros. Learn to enable or disable macros in Excel for Mac. Copy a macro module to another workbook. If a workbook contains a VBA macro that you would like to use elsewhere, you can copy the module that contains that macro to another open workbook by using the Microsoft Visual Basic Editor. Assign a macro to an object, shape ...
Working with Excel 4.0 macros - Microsoft Support
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 macros (not recommended; potentially dangerous code can run).
Active content types in your files - Microsoft Support
Active content is additional functionality in a file or program, such as macros, add-ins, or data connections. This article lists types of active content that can be blocked by the settings in Trust Center and which, when present, will cause the display of a …
Video: Work with macros - Microsoft Support
Edit a macro. Assign a macro to a button. Create and save all your macros in a single workbook. You want to automate a repetitive task in Excel, so that you can do the task again with a single click. The macro recorder is the easiest way to create a new macro in Excel.