List Shortcut Assignments

[Guest]

I have been given a workbook with many macros, some of which have already
been assigned shortcuts.

Is there an easy way to list all the macros in the workbook and the shortcut
(if any) assigned to them?

 

[WhytheQ]

If you hit the run button on the Macros toolbar and then change the
dropdown at the bottom of the Macro window to "This Workbook" then
you'll see a list of all the macros.
I'm not sure how to get a list of shortcuts.

Rgds
J

 

[Peter T]

You could try Ivan Moala's nice addin

http://www.xcelfiles.com/GetShortCutKeys.html

Regards,
Peter T

 

[Guest]

Thank you Peter
--
Gary's Student

You could try Ivan Moala's nice addin

http://www.xcelfiles.com/GetShortCutKeys.html

Regards,
Peter T