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

Hi Lee,
The usual blurb on this is...
"It's my computer. I'm in charge. It does what I want. I use a multitasking operating system so I can have more than one application
running at a time. I DO NOT want programmers to take over my computer, change settings and such. If you need control, use a
primitive single tasking o/s like DOS"

8<)


John


"leerem" wrote in message ...
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

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