Excel offers a ton of options on the Format tab for changing the shape style, shape effects, font color or size, etc. This will prevent the macro from running and allow you to modify the shape. If you need to select the shape to change its look or move it, hold the Ctrl key while clicking the shape. That's it! That's how you assign a macro to a button that you've created right on the worksheet. When you hover your mouse over the shape it will now turn into the hand pointer cursor.

If you assign the macro from another workbook, the button will not work for the people you share the workbook with.

It's important to note that the macro should be selected from the This Workbook list so that when you share the workbook with other users, the macro will be shared as well. Assign the macro (Right-click the border of the shape > Assign Macro…)Ĥ. Add text to the shape (Right-click > Edit Text | or double-click in the shape).ģ. Draw a shape on the sheet (Insert tab > Shapes drop-down > Rectangle shape).Ģ. Here are the steps to create the macro button:ġ. Shapes give us the most styling/formatting options, and we can make them look like buttons you click every day on modern web pages.īelow, we will create the button on a worksheet and assign a macro to it. In my opinion, the best way to create macro buttons is to use shapes. In this post I explain three different types of buttons you can place on a worksheet. So let's take a look at how to create a button and assign a macro to it. If you don't know how to create macros yet, then checkout one of my free webinars to learn the basics getting started with macros & VBA.

You can watch the entire video to learn more about Kristen's story with learning VBA, and how she uses macro buttons.įor this tutorial, we're using macros that have already been created.

Click here to hear Kristen's story with learning VBA Kristen, a member of our VBA Pro Course, loves to add buttons to her spreadsheets for this reason. You can literally run through a hundred steps with just one small click using macros and buttons–which, of course, is both empowering and gratifying. It's only natural to marry the two and make the processes you repeatedly have to perform as simple as possible. Create-Macro-Buttons.zip Download Making User-Friendly Macro Buttons in Your Spreadsheets

Excel command buttons stopped working