Adding a Macro to a Toolbar

Summary: Macros can make Excel much more powerful, allowing you to quickly perform repetitive tasks, process data, and do just about anything else you can think of. To make your common macros easier to use, it helps to add them to a toolbar where they are only a click away. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

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

Choose Customize from the Tools menu. Excel displays the Customize dialog box.
Make sure the Toolbars tab is selected. (Click here to see a related figure.)
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.
Click on the Commands tab. (Click here to see a related figure.)
In the list of Categories, choose the Macros entry. Your macros should then appear in the Commands list.
In the Commands list, select the macro you want assigned to a toolbar.
Using the mouse, drag the macro from the Commands list to the location on the toolbar where you want it to appear.
When you drop the macro, it appears on the toolbar.
To add more macros, repeat steps 6 through 8.
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

A Picture is Worth Thousands! Your worksheets are not limited to holding numbers and text. You can also add graphics or easily create charts based on your data. Excel Graphics and Charts, available in two versions, helps you make your graphics and charts their absolute best.

Check out Excel Graphics and Charts today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Adding a Macro to a Toolbar