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: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=530020

"John James" wrote:
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?

Try these 3 links:

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

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

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

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Chip Pearson has a good list of available shortcuts on his web site.

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

"John James" wrote:


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: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=530020

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: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=530020

"John James" wrote:
Thanks Jonathan and Max,
They're good sources for searching for standard excel shortcuts, or for
searching for macro shortcuts.

You're welcome!

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.

We were waiting for you to do it, and offer it ! <bg (just kidding)
Hang around awhile for better insights from others ..
--
Max
Singapore
http://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).

http://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: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=530020

Thanks for sharing the link, John !
--
Max
Singapore
http://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 "Excel 7
blog". Fascinating site!

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

http://blogs.msdn.com/excel/archive/...23/538311.aspx


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=530020