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" wrote in
message ...
Norman & Helge,
I've just had a quick look at this, looks pretty good:
http://www.xcelfiles.com/GetShortCutKeys.html
Regards,
Peter
-----Original Message-----
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.
---
Regards,
Norman
"Helge V. Larsen"
(AndThis) wrote in
message ...
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"
wrote
in message
...
Hi Helge,
Chip Pearson has already done the work for you!
http://www.cpearson.com/excel/ShortCuts.htm
---
Regards,
Norman
"Helge V. Larsen" <Helge.V.Larsen(RemoveThis)
@Risoe.DK
(AndThis) wrote in
message ...
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".)
.
.