Create your own buttons for macros in Excel

Table of contents:

Create your own buttons for macros in Excel
Create your own buttons for macros in Excel
Anonim

Macros in Excel can save you a lot of time when it comes to tasks with a strong repetitive nature. By assigning macros to custom buttons, you can save even more time by taking your macro just a click away from its execution.

Steps

Method 1 of 4: Excel 2003

Create a Custom Macro Button in Excel Step 1

Step #1. Click on Tools → Customize

Create a Custom Macro Button in Excel Step 2

Step #2. Click on the Toolbars tab

Create a Custom Macro Button in Excel Step 3

Step #3. Click the New button

Create a Custom Macro Button in Excel Step 4

Step 4. Type a name for your new toolbar

Create a Custom Macro Button in Excel Step 5

Step 5. Click OK

Create a Custom Macro Button in Excel Step 6

Step 6. Click on the Commands tab

Create a Custom Macro Button in Excel Step 7

Step 7. Select Macros from the list on the left

Create a Custom Macro Button in Excel Step 8

Step 8. Click and drag the Custom Button icon from the list on the right to your new toolbar

The new button is indicated by a smiley face.

Create a Custom Macro Button in Excel Step 9

Step 9. Right click on the newly added button

Create a Custom Macro Button in Excel Step 10

Step 10. Rename the button to your preference or use the default name in Name:

text box.

Create a Custom Macro Button in Excel Step 11

Step 11. Click Change Button Face

.. and possibly change the image of your button.

The Button Editor has controls similar to those of Windows Paint.

Create a Custom Macro Button in Excel Step 12

Step 12. Click on "Assign Macro

"

Create a Custom Macro Button in Excel Step 13

Step 13. Select a macro you created from the list

Create a Custom Macro Button in Excel Step 14

Step 14. Click OK

Create a Custom Macro Button in Excel Step 15

Step 15. Click Close in the Customize dialog box

Method 2 of 4: Excel 2007

Create a Custom Macro Button in Excel Step 16

Step #1. Click the small down arrow on the Quick Access Toolbar

Create a Custom Macro Button in Excel Step 17

Step #2. Click More Commands

Create a Custom Macro Button in Excel Step 18

Step 3. Select Macros from the drop-down list Choose assignments.

Create a Custom Macro Button in Excel Step 19

Step 4. Select your macro from the left column and click the Add button

Create a Custom Macro Button in Excel Step 20

Step 5. Select the macro you just added from the column on the right and click the Modify button

Create a Custom Macro Button in Excel Step 21

Step 6. Click on the button image you want to use as a representation of the macro, type the display name in the Display name text box and click on 'OK'.

Method 3 of 4: Excel 2010

561154 22

Step #1. Make sure the Developer tab is visible

The Developer tab is located in the Ribbon at the top of Excel. If this is not shown, follow the instructions below:

  • Click File → Options → Customize Ribbon.
  • Locate the Developer checkbox in the Main Tabs box and click it. Click "OK" when you're done.
561154 23

Step 2. Add a "New Group" from the Developer tab, to create a custom group for the command/button that will be created

561154 24

Step 3. Still in Customize Ribbon, click the drop-down menu to choose a command

Select Macro. After that, all recorded macros will appear in the left box.

561154 25

Step 4. Select the desired macro for creating a button (make sure the newly created group is selected) You will know if the macro has been added when it appears in the right box below your new group

561154 26

Step 5. You can now customize your button

Right click on it and select Rename. 561154 27

Step 6. When everything is ready, click on "OK"

Method 4 of 4: Excel 2013

561154 28

Step #1. Make sure the Developer tab is visible

The Developer tab is located in the Ribbon at the top of Excel. If it is not shown, follow these directions to show it:

  • Go to Excel → Preferences → Ribbon (Under Sharing and Privacy)
  • Under Customize, check the Developer tab and then click "OK"
561154 29

Step #2. Click Developer tab and click Command Button

The button icon is located in the Controls group in the Developer tab and looks like a rectangular button.

561154 30

Step 3. Insert the button

Place your cursor where you want the button and drag to resize the button. You can make the button as big or small as you want, depending on what you want. If you wish, you can move the button after placing it.

561154 31

Step #4. Assign a macro when prompted

Excel should automatically prompt you to assign a macro to your button after you place it. Once you have selected the macro, click "OK."

If you're unfamiliar with what macros are or how to record them, read about how to do that elsewhere. You will have to create a macro before you create the button

561154 32

Step 5. Make up the button

Right click on the newly created button and select "Format Control." Select Attributes → Displacement and size not related to cells → OK. This will help maintain the size and placement of your button. If you haven't chosen this attribute, the size and placement of your button will change as you add or remove cells with it.

561154 33

Step 6. Rename the button

Change the text in the button to whatever you want.

Tips

  • Try using the Excel 2003 method for older versions as well.
  • You can also optionally add your macro button to existing toolbars, in Excel 2003 and earlier.
  • If you prefer, you can assign a shortcut in the dialog box. This way you can prevent injuries to your wrist and save time.

Warnings

  • The user interface of versions earlier than Excel 2003 may differ from the method listed.
  • If you want a different button image than what Excel 2007 offers, you'll need to download additional software specifically for customizing user environments in Microsoft Office.

Popular by topic