Tag: Macro

Copy your macros to a Personal Macro Workbook

To create the personal workbook, you first need to create a macro and store it in the Personal Macro Workbook. Before you get started, make sure that the Developer tab is available in the ribbon in Excel. See Show the Developer tab for more information.

Create and update the Personal Macro workbook

  1. On the Developer tab, in the Code group, click Record Macro.
    Record Macro


  2. In the Record Macro dialog box, type a meaningful name for the macro in the Macro name box. Make sure you don’t use any spaces in the name.


  3. In the Store macro in box, select Personal Macro Workbook.
    Record Macro dialog box


  4. Click OK.


  5. Perform the actions that you want to record.


  6. On the Developer tab, in the Code group, click Stop Recording.
    Stop Recording


  7. Close the workbook.

Read More