Solved: Create shortcut

[Ruckley]

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.

[Bob Phillips]

You would use

[vba]application.OnKey "+%h","test"[/vba]

but that didn't work for me, it brought up the help menu.

[Ruckley]

Yeah, some of them are pre-defined. Shift/Alt/q works though.
Thanks a lot.

[Ruckley]

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]

Do an OnKey without the second parameter.

[Ruckley]

Yeah, that works great.

Thanks a lot.