How to Create a Macro Button In Excel 2003 & Excel 2010
After creating your first few macros you will likely grow tired of running them through the traditional user interface. Luckily for you, Microsoft has included a handy feature that allows you to create a button on your spreadsheet and assign your macro to run when it is clicked.
It's not hard to insert a button, once you get the hang of it, but it can be a little tricky the first few times.
In both Excel 2003 and 2010 buttons are located on the forms toolbar, however finding the toolbar is a little different in each. I have recorded two videos to illustrate the process of inserting a button and assigning a macro in Excel 2003 and Excel 2010 respectively.
Inserting a Macro Button in Excel 2011
Insert a Macro Button in Excel 2003
Ready to Proceed?
The next module is on VBA variables. Click here when you are ready to proceed.