When you use the example below and save the file as Excel add-in (xlam).

Menu for favorite macros in Excel 2007-2010 (for one workbook)
http://www.rondebruin.nl/qat2.htm
 
The button in the QAT will be saved in the Add-in and can be used in all open workbooks.
The only thing you must change is this: 

Remove or comment the two black code lines in the PopUpMacrowb module.

Sub WBDisplayPopUp()
' If ActiveWorkbook.Name = ThisWorkbook.Name Then
    On Error Resume Next
    Application.CommandBars(ThisWorkbook.Sheets("MenuSheet").Range("B2").Value).ShowPopup
    On Error GoTo 0
' End If
End Sub

This is very nice workaround to create an add-in with a menu for the macros you want to distribute.
With the Ribbon you can do it also but this is much easier.


If you want to have a menu for your own favorite macro's look here
http://www.rondebruin.nl/qat.htm

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