G
Guest
Hi all,
I'm trying to disable number entry in an Excel workbook. I use:
Application.OnKey "1", vbNullString
Application.OnKey "2", vbNullString
etc.
My problem is that this doesn't disable the entry of "1", "2", etc. on the numeric keypad (with NumLock on), just those above the letter keys.
Any ideas?
Thanks, Phillip
I'm trying to disable number entry in an Excel workbook. I use:
Application.OnKey "1", vbNullString
Application.OnKey "2", vbNullString
etc.
My problem is that this doesn't disable the entry of "1", "2", etc. on the numeric keypad (with NumLock on), just those above the letter keys.
Any ideas?
Thanks, Phillip