View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Disabling certain keys on keyboard

You failed because you are trying to change/control the behavior of the
operating system. This has nothing to do with Excel.

leerem wrote:

pHi Gentlemen,
I tried posting this earlier in the week but to no avial so hope the
weekend guys may be able to help.

I have a spreadsheet that AutoExecutes, and is completly run by numerous
Userforms. The Data that the User places on the form is then placed onto a
worksheet out of sight, out of mind. Hopefully

Please note there will always be a UserForm of some description on show at
full ScreenWidth and ScreenHeight.

My Problem:
There are a number of inquisitive individuals whom are able to hide,
open up Windows Forms such as 'Ease of Use Window' by pressing Windows + U,
or the Pc HardDrive window with Windows + E or by exiting the programe with
Ctrl + PauseBreak plus numerous other combinations with the Ctrl Key.

My Question how can I disable these Key combinations.

I've tried to use the Application.OnKey method but this failed or maybe I'm
doing something Dumb. I'm aware that the keystroke capture would have to be
available on all Userforms at whatever point in the process of completion the
user is at. So where would such code reside, Would this not be achieved by a
function call possibly;

Your expertise with this problem would be much appreciated
Lee