Excel.Tips.Net ExcelTips (Menu Interface)
Tips.Net > ExcelTips Home > Macros > Adding a Macro to a Toolbar

Adding a Macro to a Toolbar

Summary: A great way to customize Excel is to add your macros to a toolbar. That way you can run them quickly and easily. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Word is a very flexible program. You can configure it to work just about any way you can imagine. For instance, you can create a macro, and then add it to a toolbar. To do this, follow these steps:

  1. Choose Customize from the Tools menu. Excel displays the Customize dialog box.
  2. Make sure the Toolbars tab is selected. (Click here to see a related figure.)
  3. In the list of toolbars, make sure there is a check mark beside the toolbar to which you want your macro added. The check mark ensures that the toolbar is displayed on the screen.
  4. Click on the Commands tab. (Click here to see a related figure.)
  5. In the list of Categories, choose the Macros entry. Your macros should then appear in the Commands list.
  6. In the Commands list, select the macro you want assigned to a toolbar.
  7. Using the mouse, drag the macro from the Commands list to the location on the toolbar where you want it to appear.
  8. When you drop the macro, it appears on the toolbar.
  9. To add more macros, repeat steps 6 through 8.
  10. Click on Close.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2926) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Related Tips:

Change Formatting Based On Your Data! Conditional formatting provides a way for you to adjust the appearance of your data based on the data itself. Discover how to put this amazingly powerful feature to work for you, today. This comprehensive volume is available in two editions. Check out Excel Conditional Formatting today!