Get List of Keyboard Shortcut Bindings

[R Avery]

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]

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?&threadm=O4YdkNv1BHA.1288@tkmsftngp07

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