Important read this page if you not see the button after you reopen the file :

Where is my button that I add to the Quick Access Toolbar (QAT) of my workbook.
http://www.rondebruin.nl/qatbuttonbug.htm


Note: You can also use the example below in a Add-in, see the link on the bottom of this page.

How do I create a menu in on the QAT in Excel 2007-2010




In Excel 97-2003 it not so difficult to create a new menu on an existing menu bar or create your own
custom menu bar but in Excel 2007-2010 it is not easy to customize the Ribbon.

You have two options, or you create a Custom tab with RibbonX.
http://www.rondebruin.nl/ribbon.htm

Or you try the example below that add a popup menu to the Quick Access Toolbar (QAT)

I changed John Walkenbach‘s superb menu maker example for 97-2003 to create the PopUp menu.
Very easy to add and edit menu items with this technique.
http://www.j-walk.com/ss/excel/tips/tip53.htm


1) Download MyWorkbook.zip

2) Unzip the file and open MyWorkbook.xlsm in Excel

3) Right click on the QAT and choose Customize Quick Access Toolbar
In the “Choose commands from” dropdown choose Macros and in the Customize Quick Access Toolbar dropdown choose "For MyBook.xlsm"

Select the WBDisplayPopUp macro and press Add and then OK.
You can use Modify to change the icon if you want. Then press OK and save the file.

Note : You only have to do this one time because the button is saved with the workbook.
If you send the file to other users they can use your button on the QAT.




4) If we click on the Icon in the QAT now the menu will PopUp.

You can also use the Shortcut CTRL m  to open the menu
Note: If there is another workbook open that also use this shortcut it will run the macro
from the first file that you open in Excel.
You can change the shortcut to run the PopUp macro if you want (Alt F8, select the macro and click on options)


Edit the menu :

Right click on a sheet tab and choose Unhide if you want to change the menu
Or use "Home>Format..Hide & Unhide" in the ribbon

Read the information below :

Level: The "level" of the particular item. Valid values are 2 and 3.
A level 2 is for a menu item; and 3 is for a submenu item.

Caption: The text that appears in the menu, menu item, or submenu.
Use an ampersand (&) to specify a character that will be underlined.

Macro: For level 2 or level 3 items, this will be the macro that is executed when the item is selected.
If a level 2 item has one or more level 3 items, the level 2 item may not have a macro associated with it.
If you use Alt F11 to go to the VBA editor you can add or change your macros in the MacroModule.

Divider: True if a "divider" should be placed before the menu item or submenu item.
 
FaceID: Optional. A code number that represents the built-in graphic images that are displayed next to an item.





Edit the information in the table to make your own menu.
You can click on the “Refresh Menu” button on the worksheet to see if your changes are correct.
When It is OK click on the “Hide menu sheet” button on the worksheet and Save the file.


Tip: You can download show faceids.xlsm from John Walkenbach to find all FaceID numbers.


More Information

If you want to use the example above in a Add-in see
Menu for macros in add-in in Excel 2007 or Excel 2010
http://www.rondebruin.nl/2007addin.htm

See also this example for a menu for all workbooks
Menu for favorite macros in Excel 2007-2010 (for all workbooks)

If you want to change the Ribbon see :
Change the Ribbon in Excel 2007 or Excel 2010