First thing you have to know is the name of the macro you want to call.
If you don't know.   Go to the first module in you  personal.xls  and/or
your current workbook.  (not at same time).    then do a find  "insert"
be sure to use the  project library  radio button.    Once identified.

Ctrl + F8  (tools, macro),   select the macro form list,  Options,
  assign the shortcut key.

You might want to review: the following if you have additional
questions on this.  The shortcut would be store in your   .xlb
(toolbars)  file..
   Getting started with macros.
    http://www.mvps.org/dmcritchie/excel/excel.htm
  Backup:
    http://www.mvps.org/dmcritchie/excel/backup.htm
   Toolbars
     http://www.mvps.org/dmcritchie/excel/toolbars.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm