Disabling Shortcut Keys...

charlie79 · Mar 18th, 2002, 08:09 AM

Does anyone have experience or know how to disable shortcut keys for an excel workbook. I would like to disable such keys as ctrl+s, ctrl+o, as well as alt+f8 (displays macros shortcut menu), and any other shortcut keys that intitalize shortcut menus.

Mark O'Brien · Mar 18th, 2002, 08:32 AM

Haven't done this myself, but I know people like Juan Pablo G. have suggested this in the past.

Using VBA you can use the "OnKey" command to disable certain key combos, exmaple taken from VBA help:

This example disables the SHIFT+CTRL+RIGHT ARROW key sequence.



Application.OnKey "+^{RIGHT}", ""

HTH

charlie79 · Mar 18th, 2002, 08:42 AM

Thanks a bunch Mark. I guess it's not hard to find, but of the top of your head, what's the equivalent to "ALT" in vb code?

Mark O'Brien · Mar 18th, 2002, 08:52 AM

I believe ALT is %, off the top of my head.

Cheers

charlie79 · Mar 18th, 2002, 08:56 AM

Thanks again Mark, and I'm sorry about this, but I've been looking and can't seem to find it. What would the "F#" keys be. "F18" for example?

AllenL · Mar 18th, 2002, 08:56 AM

Hey, charlie I work at Domtar as well
I am in Cornwall Mill
Anyways
I got this from excel help. I hope this is what you need

Key Code
BACKSPACE {BACKSPACE} or {BS}
BREAK {BREAK}
CAPS LOCK {CAPSLOCK}
CLEAR {CLEAR}
DELETE or DEL {DELETE} or {DEL}
DOWN ARROW {DOWN}
END {END}
ENTER (numeric keypad) {ENTER}
ENTER ~ (tilde)
ESC {ESCAPE} or {ESC}
HELP {HELP}
HOME {HOME}
INS {INSERT}
LEFT ARROW {LEFT}
NUM LOCK {NUMLOCK}
PAGE DOWN {PGDN}
PAGE UP {PGUP}
RETURN {RETURN}
RIGHT ARROW {RIGHT}
SCROLL LOCK {SCROLLLOCK}
TAB {TAB}
UP ARROW {UP}
F1 through F15 {F1} through {F15}

You can also specify keys combined with SHIFT and/or CTRL and/or ALT. To specify a key combined with another key or keys, use the following table.

To combine keys with Precede the key code by
SHIFT + (plus sign)
CTRL ^ (caret)
ALT % (percent sign)

Mar 18th, 2002, 08:32 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Haven't done this myself, but I know people like Juan Pablo G. have suggested this in the past. Using VBA you can use the "OnKey" command to disable certain key combos, exmaple taken from VBA help: This example disables the SHIFT+CTRL+RIGHT ARROW key sequence. Application.OnKey "+^{RIGHT}", "" HTH __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Mar 18th, 2002, 08:52 AM	#4
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	I believe ALT is %, off the top of my head. Cheers __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 08:09 AM	#1
charlie79 Board Regular Join Date: Feb 2002 Posts: 97	Does anyone have experience or know how to disable shortcut keys for an excel workbook. I would like to disable such keys as ctrl+s, ctrl+o, as well as alt+f8 (displays macros shortcut menu), and any other shortcut keys that intitalize shortcut menus.

Mar 18th, 2002, 08:42 AM	#3
charlie79 Board Regular Join Date: Feb 2002 Posts: 97	Thanks a bunch Mark. I guess it's not hard to find, but of the top of your head, what's the equivalent to "ALT" in vb code?

Mar 18th, 2002, 08:56 AM	#5
charlie79 Board Regular Join Date: Feb 2002 Posts: 97	Thanks again Mark, and I'm sorry about this, but I've been looking and can't seem to find it. What would the "F#" keys be. "F18" for example?

Mar 18th, 2002, 08:56 AM	#6
AllenL Board Regular Join Date: Mar 2002 Posts: 67	Hey, charlie I work at Domtar as well I am in Cornwall Mill Anyways I got this from excel help. I hope this is what you need Key Code BACKSPACE {BACKSPACE} or {BS} BREAK {BREAK} CAPS LOCK {CAPSLOCK} CLEAR {CLEAR} DELETE or DEL {DELETE} or {DEL} DOWN ARROW {DOWN} END {END} ENTER (numeric keypad) {ENTER} ENTER ~ (tilde) ESC {ESCAPE} or {ESC} HELP {HELP} HOME {HOME} INS {INSERT} LEFT ARROW {LEFT} NUM LOCK {NUMLOCK} PAGE DOWN {PGDN} PAGE UP {PGUP} RETURN {RETURN} RIGHT ARROW {RIGHT} SCROLL LOCK {SCROLLLOCK} TAB {TAB} UP ARROW {UP} F1 through F15 {F1} through {F15} You can also specify keys combined with SHIFT and/or CTRL and/or ALT. To specify a key combined with another key or keys, use the following table. To combine keys with Precede the key code by SHIFT + (plus sign) CTRL ^ (caret) ALT % (percent sign)