Microsoft Excel - Add A User-Friendly Button To Run A Macro In Your Workbook (Excel 97/2000/2002/v. X/2003)

There are several ways to access your macros, but some of them are better suited to end users. For instance, it may be easiest for end users who don't know as much about Excel to run a macro by clicking a button. It only takes a few seconds to make this possible. First, view the Forms toolbar by:

  • Choosing View | Toolbars | Forms from the menu bar
  • Click the Button icon
  • Click on your worksheet where you'd like the button to appear
  • In the Assign Macro dialog box that displays
  • Select a macro from the Macro Name list box
  • Click OK
  • Or, if you've yet to write the macro, you can enter the macro name in the text box
  • Click the New button, and then create the macro when the Visual Basic Editor opens

Go back