ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Computers & Software»
  • Computer Science & Programming»
  • Programming Languages

How to Create a Macro Button In Excel 2003 & Excel 2010

Updated on July 24, 2012

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.

Comments

    0 of 8192 characters used
    Post Comment

    No comments yet.