Share via

Recording a Named Macro That You Can Save and Edit

  • Article

  1. Choose Macro from the Tools menu.

  2. Choose Options, and then choose New File to add the macro to a new macro file. Enter a name and a description for the file, and then choose OK.

    - or -

    Select the file name in the Macro File box to add the macro to an existing file.

    If the file name is not there, install the file, and then select it in the MacroFile box.

  3. Type a unique name for the macro in the MacroName box.

    You cannot record a macro that already exists or record to a file that is read-only.

  4. Choose Record.

  5. Type a description of the macro in the Description box in the Add Macro dialog box, and then choose OK.

  6. Perform the actions to record.

    Note   To pause recording, choose Pause. To resume recording, choose Pause again. To stop recording, choose Stop.

    When recording stops, the selected macro file opens with the insertion point in the SUB block of the newly recorded macro.

If the recorder cannot match a VBScript command to the actual command you carry out, the recorder inserts an ExecuteCommand call to carry out the command. However, if the recorder substitutes ExecuteCommand for a command that causes a dialog box to appear, the dialog box appears when you run the macro but no user input appears.

See Also

Macro Recording | Installing a Macro File

 Last updated on Friday, October 08, 2004

© 1992-2003 Microsoft Corporation. All rights reserved.