Saturday, March 4, 2017

Record a macro to automate tasks or generate code

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.

No comments:

Post a Comment