This is my second try at getting an answer to a seemingly simple question:

How to list, using a VBA code or even a macro, all the custom key
combinations and their corresponding macros which are active in the currently
open spreadsheets? The list should take into account the selection made in
the 'Macros in:' box, such as This workbook, All open workbooks or
Personal.xls.

I'd like to see which key combinations are still for the taking (instead of
the trial-and-error method I use now or having to go through all the active
macros one by one and checking under Options which key compination runs it,
to see which Ctrl-Shift-letter combinations I can still use...)

z.entropic

see:

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


for a very valuable add-in
--
Gary''s Student - gsnu200749


"z.entropic" wrote:

This is my second try at getting an answer to a seemingly simple question:

How to list, using a VBA code or even a macro, all the custom key
combinations and their corresponding macros which are active in the currently
open spreadsheets? The list should take into account the selection made in
the 'Macros in:' box, such as This workbook, All open workbooks or
Personal.xls.

I'd like to see which key combinations are still for the taking (instead of
the trial-and-error method I use now or having to go through all the active
macros one by one and checking under Options which key compination runs it,
to see which Ctrl-Shift-letter combinations I can still use...)

z.entropic

See if this gets you started.
http://www.xcelfiles.com/GetShortCutKeys.html

z. entropic wrote:
This is my second try at getting an answer to a seemingly simple question:

How to list, using a VBA code or even a macro, all the custom key
combinations and their corresponding macros which are active in the currently
open spreadsheets? The list should take into account the selection made in
the 'Macros in:' box, such as This workbook, All open workbooks or
Personal.xls.

I'd like to see which key combinations are still for the taking (instead of
the trial-and-error method I use now or having to go through all the active
macros one by one and checking under Options which key compination runs it,
to see which Ctrl-Shift-letter combinations I can still use...)

z.entropic

Great thanks both to Gary"s (or should it be Gary's?) student and JW (who
suggested the same perfect solution within 3 minutes of each other...) :-)

z.entropic

"Gary''s Student" wrote:

see:

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


for a very valuable add-in
--
Gary''s Student - gsnu200749


"z.entropic" wrote:

This is my second try at getting an answer to a seemingly simple question:

How to list, using a VBA code or even a macro, all the custom key
combinations and their corresponding macros which are active in the currently
open spreadsheets? The list should take into account the selection made in
the 'Macros in:' box, such as This workbook, All open workbooks or
Personal.xls.

I'd like to see which key combinations are still for the taking (instead of
the trial-and-error method I use now or having to go through all the active
macros one by one and checking under Options which key compination runs it,
to see which Ctrl-Shift-letter combinations I can still use...)

z.entropic