If you want to use your favorite macros in all your workbooks then you can copy the macros in
your Personal.xlsb. See this page for more info:
http://www.rondebruin.nl/personal.htm

Another option is to create a add-in with a nice menu in the QAT, see this page if you want that.


How do I use the add-in in Excel 2007




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 it is not easy to customize the ribbon.

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 the zip file with My Add-in.xlam

2) Unzip/Copy the file to a folder on your system (Use a folder that you backup sometimes).

3) Use the shortcut Alt ti (English Excel version) or
    click the Microsoft Office button, click Excel Options, click the Add-Ins tab.
    In the Manage drop-down, click Excel Add-ins, and click Go.

    Use “Browse” to select the add-in and then click on OK.
    Verify My Add-in is checked in the add-in list and then click OK.

Note: You can also open the add-in like a normal workbook for testing.

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



how do I edit the menu :

We click on the green arrow button in the QAT and choose "Edit Menu" in the menu.
You will now see the worksheet in the add-in with the menu table you see below.





Read the following information carefully:

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 “Save the Add-in” button on the worksheet to save the add-in.

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



More Information

See also this example for a menu for one workbook
Menu for favorite macros in Excel 2007 (for one workbook)
 
If you want to change the ribbon see :
Change the ribbon in Excel 2007