How to make a list of all shortcut keys

[Helge V. Larsen]

I have tried to use VBA to make a list of all user-defined shortcut keys in
Excel - but have found no object or collection that holds the definitions.
Is it at all possible ? - and if it is, then HOW ?

(System-defined shortcuts can be found by letting the Answer Wizard chew on
"Print a list of shortcut keys".)

 

[Norman Jones]

Hi Helge,

Chip Pearson has already done the work for you!

http://www.cpearson.com/excel/ShortCuts.htm

 

[Helge V. Larsen]

No, I'm sorry. Chip Pearson provides a "master list" of short-cut keys that
only includes the pre-defined short-cuts.
But I am interested in a list that (also) includes my personal short-cuts.
_________________________________________________________

 

[Norman Jones]

Hi Helge,

My apologies, I missed the vital *user-defined* qualification.

It may be possible but I am not aware of any way of returning macro shortcut
assignments.

 

[Peter T]

Norman & Helge,

I've just had a quick look at this, looks pretty good:

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

Regards,
Peter

 

[Norman Jones]

Hi Peter,

Thank you for that. It looks Xcellent!

I had in fact seen this on Ivan's site before but contrived to forgrt that I
knew of its existence.

 

[David McRitchie]

If you run it, would you report back how long it took you,
the speed of your machine, and how many shortcuts it found,
I figured it would take several hours with what I was supplied
once before -- don't know if this is the same or not.

 

[Peter T]

Hi David

ListMacro_ShortCutKeys.xla
File size 83,968, dd 2004/07/04

I doubt I have anything like as many projects to run
through as you, but for my purposes it's more than
adequately fast. Takes a second or two to "warm up" then a
few seconds for 20-30 projects (PII/350 - I like
antiques!). Most contain no shortcuts, but all the details
in those which do are correctly returned.

You can select one / some / all workbooks and/or addins so
no need to worry about it hogging your machine until
you're confident about it.

I did have a problem - code fails on some, but not all
locked projects prompting the "End" dialog. Before this a
new WB is added with a single sheet to list the shortcuts.
I guess "SheetsInNewWorkbook" is changed to 1 and not
reset because of "End". Thereafter each new WB opens with
one sheet (easily reset manually in Tools > Options >
General).

I suspect this is easily fixed and I'll mail Ivan Moalla.
That aside, I agree with Norman it is Xcellent and
recommend to anyone in need of such a utility.

Regards,
Peter

-----Original Message-----
If you run it, would you report back how long it took you,
the speed of your machine, and how many shortcuts it found,
I figured it would take several hours with what I was supplied
once before -- don't know if this is the same or not.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Peter T" <[email protected]> wrote in

message news:[email protected]...

 

[Ivan F Moala]

Hi Peter...... Thanks for that. I have amended it.
Appreciate your feedback.

: