Creating a Custom Menu

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 Commands tab.

microsoft excel docs

Scroll to the bottom of the Categories list.

Insert the new Menu on your toolbar

In the Commands list box, select "New Menu"
Drag this button to your toolbar.
For the purpose of this example I am dragging it to the Menu Bar, but you can drag it anywhere even in between existing drop-down menus or to existing toolbars.

microsoft excel docs

Enter the name of your new menu

Right mouse click the menu and select Name.
Type the name you want to appear at the top of your menu, in this case "MyCustomMenu".
You can add an ampersand character (&) before a letter to indicate this character is to be used as a shortcut key.

microsoft excel docs

Adding a Custom Button

To add command buttons to this new menu, you just drag them from the (Tools > Customise) dialog box.
You will need to drag the button and then hold the mouse over the menu until the menu drop-down appears.
Selects the Commands tab.
To add a command button choose "Macros" and then drag "Custom Button" to your drop-down menu.
To add an extension menu choose "New Menu" and then drag "New Menu" to your drop-down menu.

Removing a Custom Menu

The easiest way to remove a custom menu is to hold down the Alt key and drag the menu heading away from the toolbar.
Alternatively you can drag the menu away from the toolbar when the (Tools > Customise) dialog box is displayed.

Adding a Shortcut Menu

It is possible to assign the command to an existing shortcut menu.
Select the Toolbars tab and select "Shortcut Menus"
You can modify these menus in the normal way


Before you can add any command buttons to a new drop-down menu the drop-down menu has to have been created first.
You can insert your customised drop-down menu at a specific location on the Menu bar although this is not recommended, always add it to the end. The reason for this - is that you do not know what other addins the person may have installed.
You can copy the button by holding down the Ctrl key if you need to add a command to a number of shortcut menus.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext