Adding a Macro to a Toolbar
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. (See Figure 1.)
Figure 1. The Toolbars tab of the Customize dialog box.
- 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. (See Figure 2.)
Figure 2. The Commands tab of the Customize dialog box.
- 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 97, 2000, 2002, and 2003.
Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!
Leave your own comment:
Comments for this tip:
christopher montilla 16 Mar 2015, 02:26
I work at a hospital as admittig clerk
I would like to know if I could increment a seriesof six numbers but beginning from the two inner digits in MS Excel
only thetwo inner digits increment before the sixth digit increment when the two inner digits reach a count of 99
When it reaches 219998
the sixth digit will increment by 1
awyatt 31 Dec 2013, 14:23
Thanks for the heads-up. I'll get it fixed ASAP.
Jim Boyer 29 Dec 2013, 18:51
Good tip. I've worked on making some toolbars and macros in Excel 2003, but when I click on macros category, what shows up in the commands list is NOT the list of macros I have, but only two items: Custom menu item, custom button. How am I missing what you describe in step 5?
Ray Austin 29 Dec 2013, 13:30
At the start of this tip, I reckon the 1st word is the wrong Word !!
"Word is a very flexible program."