• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Excel Tutorials by Y. Acosta

Excel Tutorials + Tips

  • Excel Tutorials
  • Etsy Store
  • Other Resources
  • About Me
    • About Me
    • Contact Me
    • FREE Printable List of Top Excel Keyboard Shortcuts
  • FREE pdf of Top Excel Shortcuts!

Macro Buttons in Excel – ALL You Need to Know (+ video tutorial)

❤ Support Free Excel Training by Sharing -

We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)

If you’ve recorded a macro to automate spreadsheet actions, you’ll need to know how to make a macro button in Excel.

Automating your spreadsheet with macros can save you insane amounts of time.

But, sifting through a list of macros to find the one you need can be a pain.

Having a macro button to click on can be a big help!

Say you’ve created a dashboard with a pivot table, pivot charts, or other visuals that need to be updated.

you can make it easier on your client, boss, or whomever, by adding a macro button to trigger the dashboard’s refresh!

What is a Macro Button in Excel?

A macro button is an object that you can assign a macro to. It’s called a button because once you click on it, it runs the macro assigned to it.

This object can be several things – a Form Control button, a shape, picture, icon, etc.

How Do Macro Buttons Work?

Introduced in Excel 2007, the Macro button is a connection between an Excel worksheet and its programming language application.

This is called Visual Basic for Applications, more commonly known as “VBA.”

When you record a macro, its list of action steps is stored in the VBA.

Click on your macro button and Excel will get the assigned macro from the VBA and run it.

How to Make Macro Buttons in Excel

You can assign a macro to pretty much any type of object (pictures, shapes, icons, etc) in Excel. This means you have options to customize them so they match your reports or dashboards!

1. Insert a Macro Button from the Developer Tab

A common way to create a macro button is from the Controls options in the Developer tab.

Once in the Developer tab, look in the Controls section, and click on “Insert.”

Here, there are options to insert a Button from Form Controls and ActiveX Controls.

The Form Controls Button is more user-friendly, in my opinion.

Buttons in Excel Developer Controls
Buttons in Excel Developer Controls

Steps to Assign a Macro to a Form Controls Button:

  1. Go to your Developer tab
  2. In the Controls section, click on Insert (it looks like a toolbox)
  3. Under Form Controls, click on “Button”
  4. Use your cursor to draw the button on your sheet
  5. Once you are done drawing it, the Assign Macro window will pop up
  6. Select your macro
  7. Click OK
Insert Macro Button from Form Controls

You can now click on this button to run the macro!

Edit the Form Controls Macro Button

After creating your button, you may need to make some edits to it. Here are some key things you may need to do:

Change the Button Label

To change the label on your button, right-click on it and select Edit Text.

Edit Form Control Text
Edit Form Control Text
Change the Text Formatting of Your Button

To change the text formatting for your button’s label (font type, size, color, etc), right-click and select Format Control.

blank

The formatting options will be in the Font tab of the pop-up window.

Keep Your Button from Moving on Your Sheet

You may notice your button move to a different spot or change in size if you make changes to the layout of your sheet.

To keep your button from moving or resizing, you’ll need to make sure it’s set to:

“Don’t Move or Size with Cells”

To set this, right-click on your button, select Format Control, and go to the Properties tab.

If you want it to display when printed, also check off the “Print Object” box.

blank
Format Control Options for Static Button, Printing
Assign a Different Macro to Your Button

To change the macro assigned to your button, right-click on the button and select Assign Macro.

This will open the Assign Macro window and you can select a different macro.

blank
Assign Macro to Form Control

Steps to Assign a Macro to an ActiveX Button:

  1. Go to your Developer tab
  2. In the Controls section, click on Insert (it looks like a toolbox)
  3. Under ActiveX Controls, click on “Button”
  4. With your cursor, draw the button on your sheet
  5. Right-click on your new button and select View Code
  6. Here, you’ll be able to enter the macro
blank
Open ActiveX Button Code to Enter Macro

There are 3 important steps to take once the VBA window opens:

  1. From the drop-down on the top-left side of the Visual Basic Editor, make sure you’re working on the correct object.
  2. Call or enter your macro code between “Private Sub” and “End Sub”
  3. From the drop-down on the top-right side of the Visual Basic Editor, select the action you would like to trigger the button. In most cases, this will be a Click.
blank
Entering Macro in ActiveX Button

NOTE: To Edit ActiveX Buttons, you need to be in Design Mode.

To Change the Label of your ActiveX Button:

  1. Right-click on your button
  2. Select Properties
blank
Open ActiveX Button Properties
  • Edit the name of your button in the Captions field
blank
Change ActiveX Button Label

2. Assign Macro to a Picture, Shape, Text Box, or Icon

You can assign macros to more than just the “button” options in the Developer tab.

In fact, you have more options to customize your button by assigning a macro to a picture, shape, icon, sticker, or text box!

TIP: Consider using a branded image or shape as your macro button!

Whichever type of illustration you select, the steps to assigning a macro to it are the same.

Once you’ve inserted and formatted your shape (or other Excel illustration), you can link a macro to it.

Steps to assign a macro to a shape:

  1. Right click on the shape and select “Assign Macro”
  2. Select your macro
  3. Click anywhere on the worksheet or press Escape to exit out of your button
blank
Assign Macro to Picture, Shape, Icon, Text Box, etc

Make sure your button doesn’t move!

Make sure to also format your shape so that it doesn’t move or resize with the sheet.

You can find this option if you right-click, then select:

  • Format Shape
  • Shape Options
  • Size and Properties
  • Under Properties, select “Don’t Move or Size with Cells”
blank


blankblank

Learn to write macros in a DAY! This book changed my life and career. I hope it can do the same for you.


Macro Buttons in Excel (Pin for Pinterest)

Related Articles:

  • Record a Macro in Excel (Featured Image)
    What is a Macro in Excel??? + How to Make…
  • How to Debug a Macro in Excel - Tutorial
    How to Debug a Macro in Excel - Tutorial
  • How to edit a macro in Excel - Tutorial
    How to Edit a Macro in Excel - Tutorial

❤ Support Free Excel Training by Sharing -

blank

About Y. Acosta

Yil's (pronounced like "Jill") passion for Excel spreadsheets can be traced back to her days in marketing, where she spent significant time working on analytics. As a content creator, she now specializes in Excel spreadsheet tutorials. Make sure to visit the About page to learn more.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Follow us:

Latest Tutorial:

Featured image for How to Use Find & Replace to Remove Wildcard Characters in Excel article

Click Here for More Excel Tutorials!!!

Get Your FREE pdf of Top Excel Keyboard Shortcuts!

* indicates required

blank

Image-button for Invoice Template for Etsy

Copyright © 2025

  • Home
  • Excel Tutorials
  • Resources
  • About Me
  • Privacy Policy & Terms of Use
  • Disclaimer
  • Advertiser Disclosure
  • Contact Me
  • FREE Printable List of Top Excel Keyboard Shortcuts
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
SettingsAccept
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT