In an Excel 2007 Workbook I'd like to redirect or capture the ALT+1, ALT+2,
ALT+3, etc. key stroke combinations to run some navigation routines I've
written. I've tried using the following in the Workbook.Open event.

Application.OnKey "%{1}", "sNavigateToGroup1"
Application.OnKey "%{2}", "sNavigateToGroup2"
Application.OnKey "%{3}", "sNavigateToGroup3"
Application.OnKey "%{4}", "sNavigateToGroup4"
Application.OnKey "%{5}", "sNavigateToGroup5"
Application.OnKey "%{6}", "sNavigateToGroup6"

This doesn't work. If anyone has experience with this type of routine or
can point me in the right direction, I'd be very appreciative.

TIA,

Ken

Hope Ron does not mind me using his site. Here is a compehenssive discuaaion
about Application.OnKey:

http://www.rondebruin.nl/key.htm

According to the link, the only thing I would need to do is remove the curly
brackets since the numeral keys are not considered special keys. I did so,
but the key combinations still do not work.

Anybody else have any ideas?

Ken

"Philosophaie" wrote:

Hope Ron does not mind me using his site. Here is a compehenssive discuaaion
about Application.OnKey:

http://www.rondebruin.nl/key.htm

Hi,

I think Alt is a bad choice, why not try Ctrl+1...., that works fine for me.
Syntax is: "^1"

Possibly the problem with Alt is that it is the beginning of menu/ribbon
shortcut key activation, so if you press Alt+1 Excel assumes you want to run
the first QAT toolbar button. If instead you use Alt+B which is not an
assigned options it will work. The syntax being "%B"

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Ken Warthen" wrote:

According to the link, the only thing I would need to do is remove the curly
brackets since the numeral keys are not considered special keys. I did so,
but the key combinations still do not work.

Anybody else have any ideas?

Ken

"Philosophaie" wrote:

Hope Ron does not mind me using his site. Here is a compehenssive discuaaion
about Application.OnKey:

http://www.rondebruin.nl/key.htm

Looks like you only assign Alt-8 & 9 in 2007. But Ctrl-alt seems to work
with the others. Don't forget to omit the curly brackets

Regards,
Peter T


"Ken Warthen" wrote in message
...
In an Excel 2007 Workbook I'd like to redirect or capture the ALT+1,
ALT+2,
ALT+3, etc. key stroke combinations to run some navigation routines I've
written. I've tried using the following in the Workbook.Open event.

Application.OnKey "%{1}", "sNavigateToGroup1"
Application.OnKey "%{2}", "sNavigateToGroup2"
Application.OnKey "%{3}", "sNavigateToGroup3"
Application.OnKey "%{4}", "sNavigateToGroup4"
Application.OnKey "%{5}", "sNavigateToGroup5"
Application.OnKey "%{6}", "sNavigateToGroup6"

This doesn't work. If anyone has experience with this type of routine or
can point me in the right direction, I'd be very appreciative.

TIA,

Ken

Thanks for the advice. I switched to CTL and everything is working fine.

Ken

"Peter T" wrote:

Looks like you only assign Alt-8 & 9 in 2007. But Ctrl-alt seems to work
with the others. Don't forget to omit the curly brackets

Regards,
Peter T


"Ken Warthen" wrote in message
...
In an Excel 2007 Workbook I'd like to redirect or capture the ALT+1,
ALT+2,
ALT+3, etc. key stroke combinations to run some navigation routines I've
written. I've tried using the following in the Workbook.Open event.

Application.OnKey "%{1}", "sNavigateToGroup1"
Application.OnKey "%{2}", "sNavigateToGroup2"
Application.OnKey "%{3}", "sNavigateToGroup3"
Application.OnKey "%{4}", "sNavigateToGroup4"
Application.OnKey "%{5}", "sNavigateToGroup5"
Application.OnKey "%{6}", "sNavigateToGroup6"

This doesn't work. If anyone has experience with this type of routine or
can point me in the right direction, I'd be very appreciative.

TIA,

Ken



.

FWIW Ctrl-1 is one of the most common built-in shortcuts I use, maybe your
users too... Which is why I suggested Ctrl-Alt.

Regards,
Peter T

"Ken Warthen" wrote in message
...
Thanks for the advice. I switched to CTL and everything is working fine.

Ken

"Peter T" wrote:

Looks like you only assign Alt-8 & 9 in 2007. But Ctrl-alt seems to work
with the others. Don't forget to omit the curly brackets

Regards,
Peter T


"Ken Warthen" wrote in message
...
In an Excel 2007 Workbook I'd like to redirect or capture the ALT+1,
ALT+2,
ALT+3, etc. key stroke combinations to run some navigation routines
I've
written. I've tried using the following in the Workbook.Open event.

Application.OnKey "%{1}", "sNavigateToGroup1"
Application.OnKey "%{2}", "sNavigateToGroup2"
Application.OnKey "%{3}", "sNavigateToGroup3"
Application.OnKey "%{4}", "sNavigateToGroup4"
Application.OnKey "%{5}", "sNavigateToGroup5"
Application.OnKey "%{6}", "sNavigateToGroup6"

This doesn't work. If anyone has experience with this type of routine
or
can point me in the right direction, I'd be very appreciative.

TIA,

Ken



.

Thanks for the advice. I noticed my shortcuts work if I'm using the numbers
at the top of the keyboard, but not if I'm using the number keys on the
NumPad. Is there a fix for this too?

Ken

"Peter T" wrote:

FWIW Ctrl-1 is one of the most common built-in shortcuts I use, maybe your
users too... Which is why I suggested Ctrl-Alt.

Regards,
Peter T

"Ken Warthen" wrote in message
...
Thanks for the advice. I switched to CTL and everything is working fine.

Ken

"Peter T" wrote:

Looks like you only assign Alt-8 & 9 in 2007. But Ctrl-alt seems to work
with the others. Don't forget to omit the curly brackets

Regards,
Peter T


"Ken Warthen" wrote in message
...
In an Excel 2007 Workbook I'd like to redirect or capture the ALT+1,
ALT+2,
ALT+3, etc. key stroke combinations to run some navigation routines
I've
written. I've tried using the following in the Workbook.Open event.

Application.OnKey "%{1}", "sNavigateToGroup1"
Application.OnKey "%{2}", "sNavigateToGroup2"
Application.OnKey "%{3}", "sNavigateToGroup3"
Application.OnKey "%{4}", "sNavigateToGroup4"
Application.OnKey "%{5}", "sNavigateToGroup5"
Application.OnKey "%{6}", "sNavigateToGroup6"

This doesn't work. If anyone has experience with this type of routine
or
can point me in the right direction, I'd be very appreciative.

TIA,

Ken



.



.

I don't think Onkey works with the number pad in any version.

Regards,
Peter T

"Ken Warthen" wrote in message
...
Thanks for the advice. I noticed my shortcuts work if I'm using the
numbers
at the top of the keyboard, but not if I'm using the number keys on the
NumPad. Is there a fix for this too?

Ken

"Peter T" wrote:

FWIW Ctrl-1 is one of the most common built-in shortcuts I use, maybe
your
users too... Which is why I suggested Ctrl-Alt.

Regards,
Peter T

"Ken Warthen" wrote in message
...
Thanks for the advice. I switched to CTL and everything is working
fine.

Ken

"Peter T" wrote:

Looks like you only assign Alt-8 & 9 in 2007. But Ctrl-alt seems to
work
with the others. Don't forget to omit the curly brackets

Regards,
Peter T


"Ken Warthen" wrote in message
...
In an Excel 2007 Workbook I'd like to redirect or capture the ALT+1,
ALT+2,
ALT+3, etc. key stroke combinations to run some navigation routines
I've
written. I've tried using the following in the Workbook.Open event.

Application.OnKey "%{1}", "sNavigateToGroup1"
Application.OnKey "%{2}", "sNavigateToGroup2"
Application.OnKey "%{3}", "sNavigateToGroup3"
Application.OnKey "%{4}", "sNavigateToGroup4"
Application.OnKey "%{5}", "sNavigateToGroup5"
Application.OnKey "%{6}", "sNavigateToGroup6"

This doesn't work. If anyone has experience with this type of
routine
or
can point me in the right direction, I'd be very appreciative.

TIA,

Ken



.



.