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
-
Picture 1 of How to Create a Custom Macro Button in Excel Click Tools → Customize. -
Picture 2 of How to Create a Custom Macro Button in Excel Click the Toolbars tab. -
Picture 3 of How to Create a Custom Macro Button in Excel Click the New button. -
Picture 4 of How to Create a Custom Macro Button in Excel Type a name for your new toolbar. -
Picture 5 of How to Create a Custom Macro Button in Excel Click OK. -
Picture 6 of How to Create a Custom Macro Button in Excel Click the Commands tab. -
Picture 7 of How to Create a Custom Macro Button in Excel Select Macros from the list on the left. -
Picture 8 of How to Create a Custom Macro Button in Excel 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. -
Picture 9 of How to Create a Custom Macro Button in Excel Right-click on the newly added button. -
Picture 10 of How to Create a Custom Macro Button in Excel Rename the button to your liking or leave the default name in the Name: field. -
Picture 11 of How to Create a Custom Macro Button in Excel 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. -
Picture 12 of How to Create a Custom Macro Button in Excel Click "Assign Macro." -
Picture 13 of How to Create a Custom Macro Button in Excel Select a macro you created from the list. -
Picture 14 of How to Create a Custom Macro Button in Excel Click OK. -
Picture 15 of How to Create a Custom Macro Button in Excel Click Close on the Customize dialog box.
Method 2 of 4:
Excel 2007
-
Picture 16 of How to Create a Custom Macro Button in Excel Click the little arrow pointing down on the Quick Access Toolbar. -
Picture 17 of How to Create a Custom Macro Button in Excel Click More Commands. -
Picture 18 of How to Create a Custom Macro Button in Excel Select Macros from the Choose commands from list box. -
Picture 19 of How to Create a Custom Macro Button in Excel Select your macro from the left hand column and click the Add button. -
Picture 20 of How to Create a Custom Macro Button in Excel Select the macro that you just added from the right hand column and click the Modify button. -
Picture 21 of How to Create a Custom Macro Button in Excel 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
-
Picture 22 of How to Create a Custom Macro Button in Excel 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:- Click File → Options → Customize Ribbons
- Find the Developer check box in the Main Tabs section and click it. Press "OK" when you are done.
-
Picture 23 of How to Create a Custom Macro Button in Excel Add "New Group" under the Developer Tab to create a custom group for the command/button that will be created. -
Picture 24 of How to Create a Custom Macro Button in Excel 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. -
Picture 25 of How to Create a Custom Macro Button in Excel 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). -
Picture 26 of How to Create a Custom Macro Button in Excel You may now customize your button. Right-click and select Rename. -
Picture 27 of How to Create a Custom Macro Button in Excel If everything is set, Click "OK"
Method 4 of 4:
Excel 2013
-
Picture 28 of How to Create a Custom Macro Button in Excel 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:- Go to Excel → Preferences → Ribbon (Under Sharing and Privacy)
- Under Customize, check the box next to the Developer tab, and press "OK"
-
Picture 29 of How to Create a Custom Macro Button in Excel 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. -
Picture 30 of How to Create a Custom Macro Button in Excel 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. -
Picture 31 of How to Create a Custom Macro Button in Excel 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, read more. You should have a macro already built before you create the button.
-
Picture 32 of How to Create a Custom Macro Button in Excel 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. -
Picture 33 of How to Create a Custom Macro Button in Excel Rename the button. Change the text in the button to say whatever you'd like it to.
Update 05 March 2020
You should read it
- How to Add a Button to a Macro
- How to Remove a Macro in Excel
- How to Create an OpenOffice Macro
- How to turn on / off Macro in Word
- How to disable Macro mode and auto-switch on iPhone camera
- How to troubleshoot macros in Excel not working
- How to Prevent Notifications when Screen Mirroring on a Mac
- How to fix the problem of left clicking on Windows
- errno.h in C
- 20 small tricks with Edge browser you should know (Part 2)
- Create Button in CSS
- The class of macro camera of the Galaxy A51 is what users rarely see
Maybe you are interested
How to print multiple PDF files at the same time is very simple and fast What is UID in Linux? How to find and change the UID One light year is equal to how many kilometers, how many years of earth How to fix 0x00000024 error in Windows How to edit Instagram photos right on your computer 20+ images of the secret behind the lives of Japanese businessmen