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:
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…