O'Reilly logo

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Build a Toolbar

To create a toolbar in Excel:

  1. Choose Tools → Customize → Toolbars. Excel displays the Toolbars tab of the Customize dialog box.

  2. Click New. Excel display the New Toolbar dialog.

  3. Type a name for the toolbar and click OK. Excel creates a new, empty toolbar.

  4. Click the Commands tab, select a category, and drag items from the Commands list to the toolbar as shown in Figure 19-12.

    Drag commands to add them to a toolbar

    Figure 19-12. Drag commands to add them to a toolbar

  5. Right-click any button on the new toolbar to rename the button, assign a macro, or change the button image, as shown in Figure 19-13.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required