Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

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 spreadsheets can make it much easier for other users that are not familiar with Excel. Instead of having them complete a bunch of steps in a complex process, they can just click a button to run a macro. The macro runs your VBA code that automates the task(s).

Additional Resources:

How to Enable the Developer Tab in Excel: https://youtu.be/JLQ8OuW0FlY

How to Add Macro Buttons to the Ribbon (Toolbar) in Excel: https://youtu.be/dmdolFcS-fI

How to Add a Yes/No Pop-up Message Box Before a Macro Runs: https://youtu.be/rCh7ki9yVsM

Create Macro Buttons for Filters in Excel: https://youtu.be/a8r20T1c_JU

Create Macro Buttons for Pivot Tables: https://youtu.be/vLISpSGKhlQ
00:00 Introduction
00:24 VBA Edito
00:58 Insert Tab
01:35 Assigning a Macro
04:07 Moedifying the Shape
05:42 Form Controls