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