Disabling Shortcuts And Keys

[Guest]

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.

 

[Jim Cone]

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" <[email protected]>
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.