To record and save a macro

Creating macros : Recording macros : To record and save a macro

To record and save a macro

Do one of the following:

•

Click Tools } Macros } Start recording, or click the Start recording button

on the Macros toolbar, to store the macro in the default macro project for recordings.

•

In the Macro Manager docker, click the project in which to store the macro, and then click the Record button

The Record Macro dialog box appears.

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

Macro names can contain numerals, but they must begin with a letter. Macro names cannot contain spaces or non-alphanumeric characters other than underscores ( _ ).

Type a description of the macro in the Description box, and then click OK.

Perform the actions that you want to record.

The application begins recording your actions. If you want to pause recording, do one of the following:

•

Click Tools } Macros } Pause recording. Repeat this step to resume recording.

•

Click the Pause recording button

on the Macros toolbar or in the Macro Manager docker. Repeat this step to resume recording.

To stop recording, do one of the following:

•

Click Tools } Macros } Stop recording.

•

Click the Stop recording button

on the Macros toolbar or in the Macro Manager docker.

•

Press Ctrl + Shift + O.

•

You cannot record a macro if all available macro projects are locked..

•

Not all actions can be recorded — some because of their complexity (although many such actions can be manually coded in the Macro Editor). When an action cannot be recorded, a comment is placed in the macro code (“The recording of this command is not supported.”), but the recording process continues until you stop it. You can view any comments in the code by opening the macro in the Macro Editor.

•

You can specify the default macro project for recordings by right-clicking the project in the Macro Manager docker, and then clicking Set as recording project. However, you cannot specify a locked macro project.

•

You can cancel recording a macro, and discard any commands recorded thus far, by clicking Tools } Macros } Cancel recording.


You can also
Save the actions in the Undo list as a VBA macro	Click Tools } Undo, perform the actions that you want to record, and then click the Save list to a VBA macro button in the Undo docker.