#Custom shortcut bar excel 2016 code#

Save and name this second macro object, for example, mcrAddShortcutMenu. In the Menu Macro Name argument box, enter the name of the macro object that you created in Step 1. If the menu is added as a shortcut menu in Step 3, the Menu Name argument is ignored. This argument is not required, but is recommended if, in Step 3, you plan to add the menu to a Ribbon tab (such as the Add-Ins tab of a form or report). In the Menu Name argument box for the AddMenu macro action, type the name of the menu (for example, 'Form Commands'). In the Add New Action combo box on the macro design window, select AddMenu.

#Custom shortcut bar excel 2016 code#

On the Create tab, in the Macros & Code group, click Macro. This macro action is sometimes called the 'menu macro'. This step might seem redundant, but to create the shortcut menu from the macro object that you created in Step 1, you must create a second macro object that contains the AddMenu macro action. Step 2: Create a second macro object that creates the menu

The following illustration shows an example macro object with three submacros for a custom menu or shortcut menu. Save and name the macro object for example, mcrShortcutMenuCommands. If there are more actions that you want to take place when you select this command, add them as separate macro actions within the same submacro. Within the submacro, select the first action you would like to take place when you click the command on the shortcut menu.

This letter will be underlined on the menu. Tip: To create an access key so that you can use the keyboard to choose the command, type an ampersand (&) before the letter that you want to be the access key in the command name (for example, '&Refresh').