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



.



.