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>