Does someone have code to list macro shortcuts?
Ctl-Shift-F macFind
Ctl-Shift-N macNew
Ctl-Shift-X macFoo

Alternatively, it could list all of them, if there's a way to walk
through a "macros collection" or whatever:
macXXX (none)
macFind Ctl-Shift-F
macNew Ctl-Shift-N
macFoo Ctl-Shift-X
macBar (none)

There is no way to list custom shortcuts and the procedures they
point to. For standard shortcuts, see
http://www.cpearson.com/excel/shortcuts.htm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Wild Bill" wrote in message
. ..
Does someone have code to list macro shortcuts?
Ctl-Shift-F macFind
Ctl-Shift-N macNew
Ctl-Shift-X macFoo

Alternatively, it could list all of them, if there's a way to
walk
through a "macros collection" or whatever:
macXXX (none)
macFind Ctl-Shift-F
macNew Ctl-Shift-N
macFoo Ctl-Shift-X
macBar (none)

Bummer. Thanks for informing me though.

On Sun, 1 May 2005 13:24:52 -0500, Chip wrote:

There is no way to list custom shortcuts and the procedures they
point to. For standard shortcuts, see
http://www.cpearson.com/excel/shortcuts.htm

I think the following will do what you ask
Shortcuts Found in Excel Menus
http://www.mvps.org/dmcritchie/excel/shortmenu.htm

Sub ShowShortcuts_inMenus(), list short cuts found...
Sub fix_U_menu(), converts & found in tool tips caption to underscored letter

Ran in 3 seconds (2.714 secs, 1 timed test) on my PC,
600mHz machine with 512MB RAM,
Let me know if this works out for you or not. If it doesn't, I
probably won't have anything else for you, but still want to know.

Are you running on Mac, just curious why your macro begin with "mac".

I have a list of shortcuts from the HELP file Excel 2000 on
PC's. The original idea was so anyone could create their own
list. But it takes quite a bit of work to get it done, plus I kept
finding entire groups of shortcuts that I'd left out, so it is not
worth the trouble for individuals.

Shortcut Keys in Excel 2000 (Excel Vers. 9)
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Wild Bill" wrote ...
Does someone have code to list macro shortcuts?
Ctl-Shift-F macFind
Ctl-Shift-N macNew
Ctl-Shift-X macFoo

Alternatively, it could list all of them, if there's a way to walk
through a "macros collection" or whatever:
macXXX (none)
macFind Ctl-Shift-F
macNew Ctl-Shift-N
macFoo Ctl-Shift-X
macBar (none)

Thank you for your interest and effort.

On Sun, 1 May 2005 19:01:16 -0400, "David McRitchie"
wrote:

I think the following will do what you ask
Shortcuts Found in Excel Menus
http://www.mvps.org/dmcritchie/excel/shortmenu.htm

Sub ShowShortcuts_inMenus(), list short cuts found...

Today's machine is XL97, preventing use of CommandBars.FindControls. I
don't see a quick adaptation for .FindControl (no 's') which XL97 has.
So I'll try XL03 tomorrow. Oh, check a typo on your site - "pesonal.xls"

Does someone have code to list macro shortcuts?
Ctl-Shift-F macFind
Ctl-Shift-N macNew
Are you running on Mac, just curious why your macro begin with "mac".

XP on IBM PC clone. That was just a [thoughtlessly chosen]
'Hungarianish' indication that those were macro names.

Moreover, I gather that this just locates accelator-keyed controls -
right? I don't at all mean to diminish the value of your creation but
(greedy me) I'd love to get the shortcuts on every [personal] macro, if
I understand your code.

Meanwhile I just discovered Chip's
http://www.cpearson.com/excel/menus.htm in my attempt to use this in
XL97, but it relies on a common property such as .Tag. I don't see any
other property for universally ".FindControling" all controls - though
someone else might.

I'll have to find what accelerator shortcuts are.

I use "pesonal.xls" instead of "personal.xls" and try to change
documentation to personal.xls if I notice after updating web pages.

The practice was supposed to stave off viruses targeting specific files,
probably a useless device now, if it ever was valid, but I will continue
to do it this way, anyway, just in case.

If you want to see what the macro would pick up if not limited
to shortcuts look at the other macro on coding page that was not
shown on the shortmenu.htm page. You'll see that it is
going through the menus.
http://www.mvps.org/dmcritchie/excel/code/shortmenu.txt
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Wild Bill" wrote in message . ..
Moreover, I gather that this just locates accelator-keyed controls -
right? I don't at all mean to diminish the value of your creation but
(greedy me) I'd love to get the shortcuts on every [personal] macro, if
I understand your code.

Meanwhile I just discovered Chip's
http://www.cpearson.com/excel/menus.htm in my attempt to use this in
XL97, but it relies on a common property such as .Tag. I don't see any
other property for universally ".FindControling" all controls - though
someone else might.

accelerator key

A single character used as a shortcut for selecting an object. Pressing the ALT key, followed by the accelerator key gives focus to
the object and initiates one or more events associated with the object. The specific event or events initiated varies from one
object to another. If code is associated with an event, it is processed when the event is initiated. Also called keyboard
accelerator, shortcut key, keyboard shortcut.


So the answer is, no the macro provide is not limited to accelerator keys,
in fact it is specifically not showing you menu items which are only accessible
with ALT+ shortcuts via the menus. But didn't you notice that in
Ctrl+Shift+xxx shortcuts in the table included.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"David McRitchie" wrote in message ...
I'll have to find what accelerator shortcuts are.

I use "pesonal.xls" instead of "personal.xls" and try to change
documentation to personal.xls if I notice after updating web pages.

The practice was supposed to stave off viruses targeting specific files,
probably a useless device now, if it ever was valid, but I will continue
to do it this way, anyway, just in case.

If you want to see what the macro would pick up if not limited
to shortcuts look at the other macro on coding page that was not
shown on the shortmenu.htm page. You'll see that it is
going through the menus.
http://www.mvps.org/dmcritchie/excel/code/shortmenu.txt
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Wild Bill" wrote in message . ..
Moreover, I gather that this just locates accelator-keyed controls -
right? I don't at all mean to diminish the value of your creation but
(greedy me) I'd love to get the shortcuts on every [personal] macro, if
I understand your code.

Meanwhile I just discovered Chip's
http://www.cpearson.com/excel/menus.htm in my attempt to use this in
XL97, but it relies on a common property such as .Tag. I don't see any
other property for universally ".FindControling" all controls - though
someone else might.