Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a workbook that uses multiple userforms that users on the warehouse
floor enter information onto. The problem I have is that users are crashing the workbook. I've managed to disable the Break key as well as the Ctl-Alt-Delte combination However the Windows key is a bit more of a challenge, I thought I could capture the keystroke as follows: Sub UserForm_KeyDown(ByVal keycode As MSForms.ReturnInteger, ByVal _ Shift As Integer) 'Capure the KeyStroke If keycode = 92 Or keycode = 91 Then ' Throw away the Key Stroke keycode = 0 MsgBox "Your Shouldn't be pressing the Windows Key!" End If End sub But this doesn't stop the Start Window from showing. In addition this only works for a userform without any controls, How would I go about capturing these keystroke for all forms used without having to copying or placing a call routine into all KeyDown procedures. Any ideas, please help....... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Keycode description creator | Excel Discussion (Misc queries) | |||
cannot open exel from windows xp in windows vista and visa versa | New Users to Excel | |||
KeyCode | Excel Programming | |||
TextBox and KeyCode | Excel Programming | |||
detecting keycode internationally | Excel Programming |