How to Create a Custom Macro Button in Excel

PDF download Download Article
PDF download Download Article

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.

Method 1
Method 1 of 4:

Excel 2003

PDF download Download Article
  2. Advertisement
  4. for your new toolbar.
  8. The new button is represented by a smiley face.
  9. on the newly added button.
  10. field.
  11. The Button Editor has controls similar to the Windows Paint program.
  12. "
  13. Select a macro you created from the list.
    16. Advertisement
Method 2
Method 2 of 4:

Excel 2007

PDF download Download Article
  6. 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.
    7. Advertisement
Method 3
Method 3 of 4:

Excel 2010

PDF download Download Article
  1. 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.
  3. 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. Right-click and select Rename.
    7. Advertisement
Method 4
Method 4 of 4:

Excel 2013

PDF download Download Article
  1. 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"
  2. The Button icon is under the Form Controls group in the Developer tab and looks like a rectangular button.
  3. 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. 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.
  5. 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. Change the text in the button to say whatever you'd like it to.
    7. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      • Try using the 2003 method for Excel versions earlier than 2003.
        Thanks
        Helpful 0 Not Helpful 0
      • Alternatively, you may add your macro button to an existing toolbar in versions 2003 and earlier.
        Thanks
        Helpful 0 Not Helpful 0
      • If you prefer, it will let you assign a shortcut key in the dialog box. This can prevent wrist strain and save time.
        Thanks
        Helpful 0 Not Helpful 0
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      Warnings

      • The user interface on versions earlier than 2003 may be different so the 2003 method may not be exactly the same for those versions.
        Thanks
        Helpful 2 Not Helpful 0
      • If you want a different button image than what version 2007 offers, you will need to download additional software that specializes in modifying user interfaces for Microsoft Office.
        Thanks
        Helpful 2 Not Helpful 0
      Advertisement

      You Might Also Like

      How to
      Write a Simple Macro in Microsoft Excel
      How to
      Create a User Defined Function in Excel
      How to
      Apply Conditional Formatting in Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Unprotect an Excel Sheet
      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Create a Graph in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      Advertisement

      References

      1. ↑ http://office.microsoft.com/en-us/excel-help/add-a-button-and-assign-a-macro-to-it-in-a-worksheet-HP010342137.aspx

      About This Article

      In other languages
      Thanks to all authors for creating a page that has been read 488,377 times.

      Is this article up to date?

      Advertisement