Can I DISABLE a shortcut key?

C

CMIConnie

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!
 
C

Chip Pearson

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]...
 
C

CMIConnie

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...
 
C

Chip Pearson

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
 
C

CMIConnie

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