Disable Control D

[mrmikelly]

I need to diable the contol D function. I use control F function all the time and in my haste I hit the D instead of F. I'm using excel 2000.

Thanks in advance
Michael

 

[Juan Pablo González]

One way is to put this two subs in your personal macro workbook, then run the one that you want (Either enable or disable). Unfortunately, there is no direct way of disabling the shortcut key in Excel.<pre>Sub DisableCtrlD()
Application.OnKey "^d", ""
End Sub

Sub EnableCtrlD()
Application.OnKey "^d"
End Sub</pre>