Can I DISABLE a shortcut key?
 

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!

Can I DISABLE a shortcut key?
 

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





"CMIConnie" wrote in
message
...
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!

Can I DISABLE a shortcut key?
 

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

"Chip Pearson" wrote:

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





"CMIConnie" wrote in
message
...
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!

Can I DISABLE a shortcut key?
 

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


"CMIConnie" wrote in
message
...
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...

"Chip Pearson" wrote:

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





"CMIConnie" wrote in
message
...
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!

Can I DISABLE a shortcut key?
 

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

"Chip Pearson" wrote:

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


"CMIConnie" wrote in
message
...
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...

"Chip Pearson" wrote:

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





"CMIConnie" wrote in
message
...
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!