Key combinations not used by Excel to use in macro keyboard shortcuts?

[StargateFanFromWork]

From this msg:

******************************************************************************************
2007-09-13 10:21:10
(http://groups.google.ca/group/micro...RTCUT+KEY+MACRO&rnum=2&hl=en#4c218976f2b2f1cd)

IIRC...

ctrl-l, ctrl-q, ctrl-t
are not used in Excel.

ctrl-e, ctrl-m, ctrl-j
are used in the VBE, but not excel.

--

Dave Peterson
******************************************************************************************

I learned that ^1, ^q and ^t aren't used in Excel. Are there any other
combinations that aren't, by any chance? Does anyone know?

Thanks! D

 

[Guest]

If you look up keyboard shortcuts in Excel help you'll get em' all.

 

[StargateFanFromWork]

If you look up keyboard shortcuts in Excel help you'll get em' all.

I did that and also looked in the archives before ever posting. I didn't
find an answer related to this -- a whole lot of other information came
up -- but not this.

Does anyone know the answer or an actual place to get such a list? I'm
looking for FREE keyboard shortcuts not the shortcuts themselves. I use a
lot of them so I know the ones that are generally avaiable. Besides the
ones listed by Dave Peterson below, are there any other free keys? I was
hoping for at least one more. Somewhere I have code to disable and enable
my own shortcut keys and as a last resort will hunt that down, I'm just
interested in what is natively free in XL2K.

Thanks.

 

[Dave Peterson]

I think I found them in John Walkenbach's Power Programming book:
http://j-walk.com/ss/books/bookxl12.htm
(an older version)

I've never seen a list anywhere else.

I actually have those on a postit note, so I'm not sure if I really got them
from John's book.

 

[StargateFanFromWork]

Ah, post-its ... what would we do without them ...

Well, at least I have those 3 for now. I've tried the ^+Shft combinations
like Excel seems to revert to (I'm guessing when the ^+? gets changed, that
means that particular ^ combination is used up(??)) but they don't work. I
often get bumped into the font selection box which is my second toolbar
underneath the standard one.

I'll keep looking for easy out re this. I remember programming my very own
shortcuts into a sheet that absolutely had to have them, but it was a real
pain <g>.

Thanks.

 

[Dave Peterson]

Which ctrl-shift key combos didn't work for you?

Just curious.