Recording Macros

Contact Us or call 1-877-932-8228
Recording Macros

Recording Macros

To record a macro in Microsoft Excel:

  1. On the VIEW tab, in the Macros group, click the Macros command:Macros Command
  2. Click Record Macro:Record Macro
  3. In the Record Macro dialog box:
    1. Enter a Macro name. Choose a name that clearly identifies the macro. You cannot use spaces.
    2. Enter a Shortcut key. You will be able to run the macro using this shortcut key.
    3. Choose where to store the macro. You will normally accept the default (This Workbook).
    4. Enter a Description. Briefly explain what the macro does.
    5. Click OK.Explain Macro
  4. After clicking OK, every keystroke is recorded.
  5. To stop recording, on the VIEW tab, in the Macros group, click the Macros command and then click Stop Recording:Stop Recording

Copy a Macro from Workbook to Workbook

You can copy macros to different workbooks. First you need to ensure the DEVELOPER tab is active on the Ribbon. To add it:

  1. Right-click the Ribbon and select Customize the Ribbon. Customize the Ribbon Command
  2. Select Customize Ribbon, and on the right, select the Developer check box and click OK. Select Options

Now you need to enable and copy the macros:

  1. Select the DEVELOPER tab, and select Macro Security from the Code group. Macro Security
  2. Under Macro Settings, select Enable all macros and click OK. Enable All Macros
  3. Open both the source and destination workbook.
  4. Select the DEVELOPER tab, and select Visual Basic from the Code group. Visual Basic Option
  5. From the Project Explorer pane, press Ctrl and drag the module from the source to the destination workbook. Drag to Destination Workbook
  6. Close the Visual Basic window and save the workbook.
Next