Onkey Method

  • Thread starter Thread starter Fred Lambelet
  • Start date Start date
F

Fred Lambelet

I want to disable + and - keys on numeric keypad. How
do I express these keys as a string for Onkey method of
Application object. These keypad keys are apparently
"different" keys than the keys on the regular keyboard. I
have no problem disabling these same keys on the regular
keyboard, using:

Application.Onkey "-", ""
Application.Onkey "{+}", ""

On my keyboard (Gateway notebook), you press and hold the
Fn key while pressing a number or the plus key on the keys
that are embedded in the keyboard, or you can press
Fn+Pad Lock to lock on the embedded numeric keypad.

Thanks for your help!

Fred Lambelet
(e-mail address removed)
 
The consensus is that it is generally not possible, though IIRC some have
reported that using codes such as {107} works for certain PCs.
 
Vasant,
Thanks!
The {107} did work to disable the numeric keypad + key on
my computer at least. Do you know if there is a similar
code for the minus (-) key?

What I want to use this for is to prevent users from
entering formulas into unlocked data entry cells. If I
disable the = key, the formula bar, and the Insert
function menu item, I figure I can suppress this
activity. Is this approach feasible? Is there anything
else I need to look into?

What is this IIRC you referred to? I am pretty much a
novice.

Thanks again!
 
Back
Top