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 |
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 |
All times are GMT +1. The time now is 08:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com