software

When assigning a shortcut key to a macro, I cannot see which keyboard
combinations are already used by either inbuilt excel shortcuts or by
other macros.

Is there a way of seeing all keyboard combination mappings as a group?
And ideally to change them at the same time too?--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=530020quot;John Jamesquot; wrote:
gt; When assigning a shortcut key to a macro, I cannot see which keyboard
gt; combinations are already used by either inbuilt excel shortcuts or by
gt; other macros.
gt;
gt; Is there a way of seeing all keyboard combination mappings as a group?
gt; And ideally to change them at the same time too?

Try these 3 links:

www.cpearson.com/excel/KeyboardShortcuts.htm
(Chip Pearson)

www.contextures.com/excel.htm
(Debra Dalgleish)

www.xcelfiles.com/GetShortCutKeys.html
(Ivan Moala)

--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---Chip Pearson has a good list of available shortcuts on his web site.

www.cpearson.com/excel/KeyboardShortcuts.htm

quot;John Jamesquot; wrote:

gt;
gt; When assigning a shortcut key to a macro, I cannot see which keyboard
gt; combinations are already used by either inbuilt excel shortcuts or by
gt; other macros.
gt;
gt; Is there a way of seeing all keyboard combination mappings as a group?
gt; And ideally to change them at the same time too?
gt;
gt;
gt; --
gt; John James
gt; ------------------------------------------------------------------------
gt; John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
gt; View this thread: www.excelforum.com/showthread...hreadid=530020
gt;
gt;


Thanks Jonathan and Max,

They're good sources for searching for standard excel shortcuts, or for
searching for macro shortcuts.

I was hoping some guru would have developed something which combined
these into a nice interface so I could conveniently see which shortcut
combinations were available, the meaning of shortcuts in use, and maybe
even give the option to delete, add or change these.--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=530020quot;John Jamesquot; wrote:
gt; Thanks Jonathan and Max,
gt; They're good sources for searching for standard excel shortcuts, or for
gt; searching for macro shortcuts.

You're welcome!

gt; I was hoping some guru would have developed something which combined
gt; these into a nice interface so I could conveniently see which shortcut
gt; combinations were available, the meaning of shortcuts in use, and maybe
gt; even give the option to delete, add or change these.

We were waiting for you to do it, and offer it ! lt;bggt; (just kidding)
Hang around awhile for better insights from others ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---

Found this PDF file which has a more comprehensive list of
system-assigned shortcut keys (with new shortcut keys planned in Excel
7 highlighted).

www.isamrad.com/dgainer/1_02-23-2006.pdf

It'd be a good idea to build a summary table of keyboard shortcuts into
Excel help, n'est pas?--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=530020Thanks for sharing the link, John !
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---

A pleasure, Max. It's good to be able to repay the favour.If you're interested in what's coming in Excel 7, google quot;Excel 7
blogquot;. Fascinating site!

This was the link on the blog which gave the keyboard shortcuts.

blogs.msdn.com/excel/archive/...23/538311.aspx--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=530020