Leading the way in Microsoft Office Development

Step 1 - Display the Customise Toolbar dialog box

Select (Tools > Customise) to display the Customise dialog box.

Another quick way to display this dialog box is right mouse click on any toolbar and select "Customise" at the bottom.

Select the Toolbars tab and press "New".

 (View > Customise)(Toolbars tab) dialog box

You can only manipulate toolbars and menus while this dialog box is displayed.

Step 2 - Enter the name of your new toolbar

Another small dialog box will be displayed to allow you enter the name of your new toolbar.

This will then appear at the bottom of the list of toolbars in the (View > Customise) dialog box.

A new empty (floating) toolbar will appear in your workbook.

It is important to remember that a new toolbar is not workbook specific and will be available whenever Excel is open.

Toolbars can be attached to specific workbooks or addins but this is not discussed here.

Step 3 - Adding a custom button

Select the Commands tab.

Scroll to the bottom of the Categories list.

In the Commands list box, select "Custom Button"

Drag this button to your new toolbar in the location where you want it to be.

You can obtain a description of the command button by selecting the command and pressing the "Description" button.

Step 4 - Assign a macro to the button

Step 5 - Removing a Custom toolbar

Display the (Tools > Customise) dialog box and select the "Toolbars" tab.

Select the toolbar that you want to delete and press the "Delete" button.

You will receive a prompt asking you to confirm the deletion.

Once a custom toolbar has been deleted it cannot be restored.

You cannot delete any of the built-in toolbars.

There is no way to attach or remove toolbars to documents and templates using VBA.

Step 6 - Things to Remember

Any changes that you make while the (Tools > Customise) dialog box is displayed are permanent