How to Create a Custom Macro Button in Excel

This updated guide examines How to Create a Custom Macro Button in Excel and organizes the essential facts, background, and practical takeaways in clear American English.

Method 1

Excel 2003

1. ClickTools ? Customize.
2. Click the Toolbars tab.
3. Click the New button.
4. Type a namefor your new toolbar.
5. Click OK.
6. Click the Commands tab.
7. Select Macros from the list on the left.
8. Click and drag theCustom Buttonicon from the list on the right to your new toolbar. The new button is represented by a smiley face.
9. Right-clickon the newly added button.
10. Rename the button to your liking or leave the default name in the Name: field.
11. ClickEdit 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. Click "Assign Macro."
13. Select amacroyou created from the list.
14. Click OK.
15. Click Close on the Customize dialog box.

Method 2

Excel 2007

1. Click the little arrow pointing down on the Quick Access Toolbar.
2. ClickMore Commands.
3. SelectMacrosfrom theChoose commands fromlist box.
4. Select your macro from the left hand column and click the Add button.
5. Select the macro that you just added from the right hand column and click the Modify button.
6. Click the button image you want to represent your macro, type the display name you want in theDisplay nametext box and click the 'OK'button.

Method 3

Excel 2010

1. 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 to display it:
   • Click File ? Options ? Customize Ribbons
   • Find the Developer check box in the Main Tabs section and click it. Press "OK" when you are done.
2. Add "New Group" under the Developer Tab to create a custom group for the command/button that will be created.
3. 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. 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. You may now customize your button. Right-click and select Rename.
6. If everything is set, Click "OK"

Method 4

Excel 2013

1. 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]XResearch source}to display it:
   • Go to Excel ? Preferences ? Ribbon (Under Sharing and Privacy)
   • Under Customize, check the box next to the Developer tab, and press "OK"
2. 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. 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. 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."
   • If you are unfamiliar with what macros are or how to record them, You should have a macro already built before you create the button.
5. 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. Rename the button. Change the text in the button to say whatever you'd like it to.