how to disable the ctrl-d shortcut in excel

problem:

how many times have you lost data pressing accidentally the ctrl-d in excel??? the drop short is between save and find... it is very famous this kind of mistake if you are using the ctrl-f...

solution:

there is no way to disable it from the excel's options... you have to do create macro...
1. from ribbon go to "view" -> macros -> "view macros"
2. in the name field type: "disableCtrlD" without quotes and press the "create" button
3. in the this new code window will appear... delete all line and paste the follow 3 lines
        Sub disableCtrlD()
            Application.OnKey "^d", ""
        End Sub
4. close the entire application / window: "Microsoft Visual Basic for Applications"
5. you have finished, the ctrl-d should not work any more.

this is working with all excel's versions (till 2010) but the way you define the macros might be different