Is it possible to write code that goes through each macro in the Macro
Dialog box and gets the assigned shortcut key (if any)?

I know that you can create shortcut key bindings with
application.macrooptions, but how do you get a list of procedure names, and
how do you then use that to get a list of all the shortcut keys that have
already been assigned to the macros?

Any help would be most appreciated.


-Robert

Tim Childs posted a routine that seemed to work for him in xl2002 (but he said
that it didn't in xl2k):

http://groups.google.com/groups?&thr...%40tkmsftngp07

It relies heavily on Sendkeys so I'm not sure if I'd use it for anything
important.



R Avery wrote:

Is it possible to write code that goes through each macro in the Macro
Dialog box and gets the assigned shortcut key (if any)?

I know that you can create shortcut key bindings with
application.macrooptions, but how do you get a list of procedure names, and
how do you then use that to get a list of all the shortcut keys that have
already been assigned to the macros?

Any help would be most appreciated.

-Robert

--

Dave Peterson