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?
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
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!
 
Upvote 0

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top