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.)

1. Choose Customize from the Tools menu. Excel displays the Customize dialog box.
2. Make sure the Toolbars tab is selected. (Click view to see a related figure

   
   The Toolbars tab of the Customize dialog box.
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 view to see a related figure

   
   The Commands tab of the Customize dialog box.
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.

• Add Combo Box to Sheet in Microsoft Excel
• The best tricks in Excel
• Create User Forms in Microsoft Excel
• Using Loops in VBA in Microsoft Excel