Redirecting ALT+1 keystrokes to run routine

[Ken Warthen]

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

 

[Philosophaie]

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

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

 

[Ken Warthen]

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

 

[Peter T]

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

 

[Shane Devenshire]

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"

 

[Ken Warthen]

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

Ken

 

[Peter T]

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]

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]

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

Regards,
Peter T