Redirecting ALT+1 keystrokes to run routine

  • Thread starter Thread starter Ken Warthen
  • Start date Start date
K

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
 
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
 
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
 
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"
 
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
 
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
 
Back
Top