Recording a new macro

When you start recording a macro, information about each level of a series of commands gets saved. You can run the commands again by running the saved macro.

Steps

To record a macro

  1. Select View > Macros > View Macros.

    Or, click the Record Macro  icon on the status bar.

  2. In the Record Macro dialog box, type macro name and click OK. In this example, type Macro1.
  3. Record macro content in the worksheet.
    In this example, make borders for the cell A1 with thick lines and change fill colors.

To stop recording a macro

  1. Select View > Macros > View Macros.
  2. In the Record Macro dialog box, type macro name and click OK. In this example, type Macro2.
  3. Record macro content in the worksheet.
  4. Click View > Macros > Stop Recording.
    Or, click the Stop Recording  icon on the status bar to stop recording a macro.
 
Was this article helpful?
0 out of 0 found this helpful