Programming Excel with VBA and .NET

Change Existing Menus

You can also add built-in commands or create new custom commands on existing Excel menus. To add built-in command to an existing menu:

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

2. In the Categories list, choose the category of the existing command you want to add. Each category contains a long list of commands, so you may need to check a couple different categories before you find the command you want.

3. Drag the existing command from the Commands list onto the top-level menu you want to add it to. Excel displays the menu once you drag over it and you can drag the command down to the position where you want it to appear on the menu as shown in Figure 19-8.

4. Click Close on the Customize dialog box when you are done adding items and setting menu properties.

To add a new custom command to an existing menu, repeat the preceding procedure, but select Macros from the Categories list and Custom Menu Item from the Commands list in Step 2. You can then rename and assign a macro to the new menu item as shown in Figure 19-7.

Figure 19-8. Dragging an existing command onto a menu