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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

StargateFanFromWork - 14 Sep 2007 14:16 GMT

From this msg:

******************************************************************************************
2007-09-13 10:21:10
(http://groups.google.ca/group/microsoft.public.excel.programming/browse_thread/t
hread/ad956fa214d85c09/4c218976f2b2f1cd?lnk=gst&q=SHORTCUT+KEY+MACRO&rnum=2&hl=e
n#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.

Signature

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! :oD

Reply to this Message

Kevin B - 14 Sep 2007 16:42 GMT

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

Signature

Kevin Backmann

> From this msg:
>
[quoted text clipped - 9 lines]
> ctrl-e, ctrl-m, ctrl-j
> are used in the VBE, but not excel.

Reply to this Message

StargateFanFromWork - 14 Sep 2007 16:56 GMT

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

>> From this msg:
>>
[quoted text clipped - 9 lines]
>> ctrl-e, ctrl-m, ctrl-j
>> are used in the VBE, but not excel.

Reply to this Message

Dave Peterson - 14 Sep 2007 17:56 GMT

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.

> > If you look up keyboard shortcuts in Excel help you'll get em' all.
>
[quoted text clipped - 38 lines]
> >>
> >> Thanks! :oD

Signature

Dave Peterson

Reply to this Message

StargateFanFromWork - 14 Sep 2007 20:36 GMT

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.

>I think I found them in John Walkenbach's Power Programming book:
> http://j-walk.com/ss/books/bookxl12.htm
[quoted text clipped - 51 lines]
>> >>
>> >> Thanks! :oD

Reply to this Message

Dave Peterson - 14 Sep 2007 21:47 GMT

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

Just curious.

> Ah, post-its ... what would we do without them ...
>
[quoted text clipped - 69 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message