Can I DISABLE a shortcut key?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to DISABLE the shortcut key (ctrl+D) which is Fill Down? I am
needing to use ctrl+F frequently and sometimes I accidently hit ctrl+D and my
spreadsheet is so huge that it locks up when I do that, then I loose all my
changes. It takes a while to save, so it is impractical to save after ever
change I make. Thanks for your time and any help you can suggest will be
appreciated!
 
You can do this with VBA code.

Sub DisableCtrlD()
Application.OnKey "^d",""
End Sub

Sub RestoreCtrlD()
Application.OnKey "^d"
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





message
news:[email protected]...
 
Thanks for your time answering my question... Would I run it as a macro?
It's been 14 years since I've written macros and I know it is different now...
 
In Excel, press ALT+F11 to open the VBA Editor. There, go to the
Insert menu and choose Module. Paste the code in that module.
Then, close the VBA Editor to go back to Excel. Press ALT+F8 to
display the macro list. Select the macro to run and click the Run
button.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
 
It worked! Thank you! Thank you! Thank you!
I love learning something new. You just made my life easier!
Happy Easter...
 
Back
Top