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".)

Hi Helge,

Chip Pearson has already done the work for you!

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

---
Regards,
Norman



"Helge V. Larsen" (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".)

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" (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".)

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" (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".)

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"
(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".)








.

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.


---
Regards,
Norman



"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"
(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".)








.

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"
(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".)








.

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".)








.



.

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

:

--
Ivan F Moal

-----------------------------------------------------------------------
Ivan F Moala's Profile: http://www.excelforum.com/member.php...nfo&userid=195
View this thread: http://www.excelforum.com/showthread.php?threadid=26634