Record a macro to automate tasks or generate code

  1. On the Tools menu, point to Macros, and then click Record New Macro.

  2. In the Macro name box, type a name for the macro.

  3. In the Shortcut key box, type a shortcut key that can be used with the CTRL key to run the macro.

  4. In the Store macro in box, click the document in which you want to store the macro.

  5. In the Description box, type a description for the macro.

  6. Click OK to begin recording the macro.

  7. Perform the actions you want to include in your macro.

    When you record a macro, you can use the mouse to click commands and options, and to work with shapes and objects in drawings.

  8. To stop recording your macro, click Stop Recording in the floating Recording toolbar.

    You can also pause or resume macro recording using the Recording toolbar.

    To view the resulting code, on the Tools menu, point to Macros, click Macros, click the macro name, and then click Edit.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.