HomeApplicationOffice information

How to Create a Custom Macro Button in Excel

Macros in Excel can save a great deal of time with repetitive tasks. By assigning macros to custom buttons, you can save even more time by bringing your macro only one-click from execution. Click Tools → Customize.
Method 1 of 4:

Excel 2003

  1. How to Create a Custom Macro Button in Excel Picture 1How to Create a Custom Macro Button in Excel Picture 1
    Click Tools → Customize.
  2. How to Create a Custom Macro Button in Excel Picture 2How to Create a Custom Macro Button in Excel Picture 2
    Click the Toolbars tab.
  3. How to Create a Custom Macro Button in Excel Picture 3How to Create a Custom Macro Button in Excel Picture 3
    Click the New button.
  4. How to Create a Custom Macro Button in Excel Picture 4How to Create a Custom Macro Button in Excel Picture 4
    Type a name for your new toolbar.
  5. How to Create a Custom Macro Button in Excel Picture 5How to Create a Custom Macro Button in Excel Picture 5
    Click OK.
  6. How to Create a Custom Macro Button in Excel Picture 6How to Create a Custom Macro Button in Excel Picture 6
    Click the Commands tab.
  7. How to Create a Custom Macro Button in Excel Picture 7How to Create a Custom Macro Button in Excel Picture 7
    Select Macros from the list on the left.
  8. How to Create a Custom Macro Button in Excel Picture 8How to Create a Custom Macro Button in Excel Picture 8
    Click and drag the Custom Button icon from the list on the right to your new toolbar. The new button is represented by a smiley face.
  9. How to Create a Custom Macro Button in Excel Picture 9How to Create a Custom Macro Button in Excel Picture 9
    Right-click on the newly added button.
  10. How to Create a Custom Macro Button in Excel Picture 10How to Create a Custom Macro Button in Excel Picture 10
    Rename the button to your liking or leave the default name in the Name: field.
  11. How to Create a Custom Macro Button in Excel Picture 11How to Create a Custom Macro Button in Excel Picture 11
    Click Edit Button Image... and change the image for your button or leave it the same. The Button Editor has controls similar to the Windows Paint program.
  12. How to Create a Custom Macro Button in Excel Picture 12How to Create a Custom Macro Button in Excel Picture 12
    Click "Assign Macro."
  13. How to Create a Custom Macro Button in Excel Picture 13How to Create a Custom Macro Button in Excel Picture 13
    Select a macro you created from the list.
  14. How to Create a Custom Macro Button in Excel Picture 14How to Create a Custom Macro Button in Excel Picture 14
    Click OK.
  15. How to Create a Custom Macro Button in Excel Picture 15How to Create a Custom Macro Button in Excel Picture 15
    Click Close on the Customize dialog box.
Method 2 of 4:

Excel 2007

  1. How to Create a Custom Macro Button in Excel Picture 16How to Create a Custom Macro Button in Excel Picture 16
    Click the little arrow pointing down on the Quick Access Toolbar.
  2. How to Create a Custom Macro Button in Excel Picture 17How to Create a Custom Macro Button in Excel Picture 17
    Click More Commands.
  3. How to Create a Custom Macro Button in Excel Picture 18How to Create a Custom Macro Button in Excel Picture 18
    Select Macros from the Choose commands from list box.
  4. How to Create a Custom Macro Button in Excel Picture 19How to Create a Custom Macro Button in Excel Picture 19
    Select your macro from the left hand column and click the Add button.
  5. How to Create a Custom Macro Button in Excel Picture 20How to Create a Custom Macro Button in Excel Picture 20
    Select the macro that you just added from the right hand column and click the Modify button.
  6. How to Create a Custom Macro Button in Excel Picture 21How to Create a Custom Macro Button in Excel Picture 21
    Click the button image you want to represent your macro, type the display name you want in the Display name text box and click the 'OK' button.
Method 3 of 4:

Excel 2010

  1. How to Create a Custom Macro Button in Excel Picture 22How to Create a Custom Macro Button in Excel Picture 22
    Make sure the Developer tab is displayed. The Developer tab is a tab in the Ribbon at the top of Excel. If it is not displayed, follow these directions in order to display it:
    1. Click File → Options → Customize Ribbons
    2. Find the Developer check box in the Main Tabs section and click it. Press "OK" when you are done.
  2. How to Create a Custom Macro Button in Excel Picture 23How to Create a Custom Macro Button in Excel Picture 23
    Add "New Group" under the Developer Tab to create a custom group for the command/button that will be created.
  3. How to Create a Custom Macro Button in Excel Picture 24How to Create a Custom Macro Button in Excel Picture 24
    Still in the Customize Ribbon, click on the dropdown menu to choose command. Select Macro. Thereafter, all recorded macros will appear in the left box.
  4. How to Create a Custom Macro Button in Excel Picture 25How to Create a Custom Macro Button in Excel Picture 25
    Select the desired macro for button creation (make sure the newly added group is highlighted, you will know if the macro was added when it appear in the right box under your new group).
  5. How to Create a Custom Macro Button in Excel Picture 26How to Create a Custom Macro Button in Excel Picture 26
    You may now customize your button. Right-click and select Rename.
  6. How to Create a Custom Macro Button in Excel Picture 27How to Create a Custom Macro Button in Excel Picture 27
    If everything is set, Click "OK"
Method 4 of 4:

Excel 2013

  1. How to Create a Custom Macro Button in Excel Picture 28How to Create a Custom Macro Button in Excel Picture 28
    Make sure the Developer tab is displayed. The Developer tab is a tab in the Ribbon at the top of Excel. If it is not displayed, follow these directions[1] in order to display it:
    1. Go to Excel → Preferences → Ribbon (Under Sharing and Privacy)
    2. Under Customize, check the box next to the Developer tab, and press "OK"
  2. How to Create a Custom Macro Button in Excel Picture 29How to Create a Custom Macro Button in Excel Picture 29
    Click on the Developer tab and click Button. The Button icon is under the Form Controls group in the Developer tab and looks like a rectangular button.
  3. How to Create a Custom Macro Button in Excel Picture 30How to Create a Custom Macro Button in Excel Picture 30
    Place your button. Place your cursor where you'd like the button to go and drag to select the size of the button. You can make the button as small or as large as you'd like, given your needs. If you wish, you can move the button around after placement.
  4. How to Create a Custom Macro Button in Excel Picture 31How to Create a Custom Macro Button in Excel Picture 31
    Assign a macro when prompted. Excel should automatically prompt you to assign a macro to your button after you finish placing it. Once you've selected your macro, click "OK."
    1. If you are unfamiliar with what macros are or how to record them, read more. You should have a macro already built before you create the button.
  5. How to Create a Custom Macro Button in Excel Picture 32How to Create a Custom Macro Button in Excel Picture 32
    Format the button. Right-click on the newly created button and select "Format Control." Select Properties → Don't move or size with cells → OK. This helps you maintain the size and placement of your button. If you don't have this property chosen, your button size and placement will change if you have it add, delete, or move cells.
  6. How to Create a Custom Macro Button in Excel Picture 33How to Create a Custom Macro Button in Excel Picture 33
    Rename the button. Change the text in the button to say whatever you'd like it to.
4 ★ | 1 Vote
buttonclicktabmacro

You should read it

May be interested

Office information