How to Create Macro Buttons in Excel Worksheets




About this tutorial:

Video duration: 8:29
In this video I explain the 3 ways to create macro buttons in Excel worksheets. These are buttons that run macros when the button is pressed. Download the Excel file:

There are 3 ways to add macro buttons to a worksheet in Excel:
1. Shapes
2. Form Control buttons
3. ActiveX buttons

In the video I explain my favorite method, and the pros & cons of each.

I also explain how to prevent the buttons from moving and resizing when changes are made to the sheet. This can happen when you add/remove rows & columns, or adjust row height or column width.

Adding macro buttons to your…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

15 thoughts on “How to Create Macro Buttons in Excel Worksheets

    Salim Saba

    (March 23, 2019 - 6:45 pm)

    Thanks Jon. That is brilliant.
    🌟 🌟 🌟 🌟 🌟

    Oliver Oshkosh

    (March 23, 2019 - 6:45 pm)

    I got lost at 0:08

    Rosemary Findley

    (March 23, 2019 - 6:45 pm)

    Nice tip. Thanks

    Source!!!

    (March 23, 2019 - 6:45 pm)

    There is no link on how to create the Macro in the tutorial. These videos are too short.

    Mark S

    (March 23, 2019 - 6:45 pm)

    How can a hot-key (not macro) be assigned to a button?

    fatihkaran

    (March 23, 2019 - 6:45 pm)

    Hi Jon, when I create a button and assign a macro to it, everytime I click (and run the macro) the button disappears. Do you have a solution for this behaviour? I did try the properties options, but it didn't help

    Yulin Liu

    (March 23, 2019 - 6:45 pm)

    Excellent tutorial! Much appreciated!

    Md. Saiful Islam Tuku

    (March 23, 2019 - 6:45 pm)

    Thanks-Jon

    Alwayspositive 999

    (March 23, 2019 - 6:45 pm)

    Great video Jon – you explain very clearly and it's great listening to your videos and learning from them. Thanks

    Wayne Edmondson

    (March 23, 2019 - 6:45 pm)

    Hey Jon.. thanks for the video on adding macro buttons. Question: Is there any way to get a shape to exhibit the "press" visualization that you see when clicking on a Form Control button? It looks like the Form Control press moves the dark border outline from the bottom and right edges to the top and left edges which gives the appearance of a "press" or "indentation.". Have you ever tried to accomplish the same via code to get that kind of animation effect on your shape buttons? Just curious.. might be a fun project. On shapes, I often use the rectangle with gradient fill and a round bevel shape effect to give the appearance of depth. But, it does not "depress" on a click. It would be great if Microsoft would add a "Like Control Button" shape effect for those of us who want to see a button-like action on the click of a shape being used as a button to fire a macro. Thanks again for all your valuable tips and resources Jon. Thumbs up!

    RAJESH GHAI

    (March 23, 2019 - 6:45 pm)

    Sir how filter formula appear in excel

    James Williams

    (March 23, 2019 - 6:45 pm)

    Always great to use your teaching and glean from your insight. I've usually just used Form Control but I like the shape attributes. Will definitely being using this one. Your free vba macro webinars are supper – your website superb. You are one of the best Jon. THANKS!

    Travis Evans

    (March 23, 2019 - 6:45 pm)

    Thanks a lot for the video, helpful as always!

    James Marasco

    (March 23, 2019 - 6:45 pm)

    Excellent tutorial!

Leave a Reply

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