Deactivating Windows Shortcuts

Chuck6475

Board Regular
Joined
Sep 30, 2012
Messages
126
Application requires users to enter data through a UserForm. Think of it as a Kiosk where the user can have a variety of computer skills.

I'm trying to make it "bulletproof".

My issue is with Windows shortcuts, like "Win + down arrow" which minimizes the application. Is there a way to deactivate these shortcuts while the application is running?
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Gideon1973

Board Regular
Joined
Apr 23, 2012
Messages
126
While not a complete answer (more of a nudge in the right direction), you may consider looking at the UserForm_KeyDown() event. This event fires whenever a key is pressed while focus is on your user form. There is a KeyCode parameter which returns an integer value for the key that's pressed. Also, you can examine the Shift parameter to determine if there was an "accompanying" key held down while the key was pressed (such as the shift key, Windows key, etc.)

Once you determine the integer values for the keystroke combination you're after, you can check for these values in the UserForm_KeyDown() event, and if you encounter it, you can see about cancelling the event.

Another consideration is to try to configure Group Policy for the user(s) and/or computer to disable certain events/behaviors that can/can't be done on that workstation.

Hope that helps!
 

Watch MrExcel Video

Forum statistics

Threads
1,099,045
Messages
5,466,227
Members
406,474
Latest member
osama beskales

This Week's Hot Topics

Top