I want to disable shortcut keys on workbook open but I don't want to upset anyone. How can I test for shortcut key assignment, so I can save and restore when the workbook closes? With other application settings I just tested with a msgbox. With the shortcut keys that doesn't work.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Disable short cut keys
- Thread starter dcoledc
- Start date
MrKowz
Well-known Member
- Joined
- Jun 30, 2008
- Messages
- 6,653
- Office Version
- 365
- 2016
- Platform
- Windows
Give these a go:
Code:
Public Sub DisableShortcuts()
With Application
.OnKey "^c", ""
.OnKey "^v", ""
.OnKey "^w", ""
.OnKey "^x", ""
End With
End Sub
Public Sub EnableShortcuts()
With Application
.OnKey "^c"
.OnKey "^v"
.OnKey "^w"
.OnKey "^x"
End With
End Sub
Upvote
0
When I turn off toolbars. etc, I first test to see if the user already has them on or not. This way when I close the workbook, I can set them back to there original settings. I am trying to do the same thing with the shortcut keys. Meaning, if the user has assigned Ctrl "^C" to do something other than copy and then I go and set to defualt that is going to upset some folks.
Having said that, is there a way to test for shorcut key assignment?
Forgive me, if you already understood this is what I was asking. I coulnd't tell from your response.
Having said that, is there a way to test for shorcut key assignment?
Forgive me, if you already understood this is what I was asking. I coulnd't tell from your response.
Upvote
0
Similar threads
- Question
