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?
--
Gary's Student

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



On Oct 18, 2:15 pm, Gary''s Student
wrote:
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?
--
Gary's Student

You could try Ivan Moala's nice addin

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

Regards,
Peter T

"Gary''s Student" wrote in message
...
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?
--
Gary's Student

Thank you Peter
--
Gary's Student


"Peter T" wrote:

You could try Ivan Moala's nice addin

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

Regards,
Peter T

"Gary''s Student" wrote in message
...
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?
--
Gary's Student