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:
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.