Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Shortcuts And Keys
is there an easy way of disabling all shortcut combinations as well as all
the keys on the keyboard. I am aware of Application.interactive. I need the user to be able to click various buttons on the worksheet as well as type text and numbers in a userform. Apart from that, how do I turn off/disable everything else. I have been using application.onkey - loads of code. Is there an easier more efficient way. -- Roger |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Shortcuts And Keys
Roger,
Why not add a series of option/checkbox buttons to the userform and delete all of your onkey code? A userform optionbutton can call a macro... Private Sub OptionButton1_Click() Call MyMacroToDoStuff End Sub -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Roger" wrote in message is there an easy way of disabling all shortcut combinations as well as all the keys on the keyboard. I am aware of Application.interactive. I need the user to be able to click various buttons on the worksheet as well as type text and numbers in a userform. Apart from that, how do I turn off/disable everything else. I have been using application.onkey - loads of code. Is there an easier more efficient way. -- Roger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disabling the Key board shortcuts | Excel Programming | |||
Keyboard Shortcuts combinations of function keys, c... | Excel Worksheet Functions | |||
Disabling Keys | Excel Programming | |||
Disabling Ctrl, ALT keys | Excel Programming | |||
Shortcuts keys sometimes don't work | Excel Programming |