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








.