PDA

View Full Version : Solved: Create shortcut


Ruckley
05-09-2011, 04:29 AM
Hi.

Is there a way of creating a shortcut in excel?

I would like to create a new keystrok combination, say for instance Shift/Alt/H/ to fire off some code.

Thanks.

:thumb
Bob Phillips
05-09-2011, 05:02 AM
You would use

application.OnKey "+%h","test"

but that didn't work for me, it brought up the help menu.
Ruckley
05-09-2011, 05:08 AM
Yeah, some of them are pre-defined. Shift/Alt/q works though.
Thanks a lot.
Ruckley
05-09-2011, 05:09 AM
On another note, any idea how to disable existing key-strokes?
I would like to diasble Alt+F11 (to show the VB editor)
Bob Phillips
05-09-2011, 06:23 AM
Do an OnKey without the second parameter.
Ruckley
05-10-2011, 06:45 AM
Yeah, that works great.

Thanks a lot. :cool: