I would add a debug.print statements to
listfunctions and sub (see buildtoc.htm) look for "application.onkey"
and include the workbook and module name in front
remember that VBA is case sensitive.
Dependent upon the shortcut being on the same line, but presume you
are documenting your own code.
Since you can turn shortcuts on and off and have several within a
module, it wouldn't work well to add a column to show a shortcut
but the debug should work okay and you can paste that into something else.
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
http://www.mvps.org/dmcritchie/excel.../listfsubs.txt
---HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htmSearch Page:
http://www.mvps.org/dmcritchie/excel/search.htm "Gary''s Student"
wrote in message ...
What is the easiest way to display the shortcut keys assigned to subs within
a module from VBA?
--
Gary's Student