software

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 quot;^dquot;,quot;quot;
End Sub

Sub RestoreCtrlD()
Application.OnKey quot;^dquot;
End Sub--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;CMIConniequot; gt; wrote in
message
...
gt; Is there a way to DISABLE the shortcut key (ctrl D) which is
gt; Fill Down? I am
gt; needing to use ctrl F frequently and sometimes I accidently hit
gt; ctrl D and my
gt; spreadsheet is so huge that it locks up when I do that, then I
gt; loose all my
gt; changes. It takes a while to save, so it is impractical to
gt; save after ever
gt; change I make. Thanks for your time and any help you can
gt; suggest will be
gt; appreciated!
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...

quot;Chip Pearsonquot; wrote:

gt; You can do this with VBA code.
gt;
gt; Sub DisableCtrlD()
gt; Application.OnKey quot;^dquot;,quot;quot;
gt; End Sub
gt;
gt; Sub RestoreCtrlD()
gt; Application.OnKey quot;^dquot;
gt; End Sub
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt;
gt;
gt;
gt; quot;CMIConniequot; gt; wrote in
gt; message
gt; ...
gt; gt; Is there a way to DISABLE the shortcut key (ctrl D) which is
gt; gt; Fill Down? I am
gt; gt; needing to use ctrl F frequently and sometimes I accidently hit
gt; gt; ctrl D and my
gt; gt; spreadsheet is so huge that it locks up when I do that, then I
gt; gt; loose all my
gt; gt; changes. It takes a while to save, so it is impractical to
gt; gt; save after ever
gt; gt; change I make. Thanks for your time and any help you can
gt; gt; suggest will be
gt; gt; appreciated!
gt;
gt;
gt;

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.comquot;CMIConniequot; gt; wrote in
message
...
gt; Thanks for your time answering my question... Would I run it as
gt; a macro?
gt; It's been 14 years since I've written macros and I know it is
gt; different now...
gt;
gt; quot;Chip Pearsonquot; wrote:
gt;
gt;gt; You can do this with VBA code.
gt;gt;
gt;gt; Sub DisableCtrlD()
gt;gt; Application.OnKey quot;^dquot;,quot;quot;
gt;gt; End Sub
gt;gt;
gt;gt; Sub RestoreCtrlD()
gt;gt; Application.OnKey quot;^dquot;
gt;gt; End Sub
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Cordially,
gt;gt; Chip Pearson
gt;gt; Microsoft MVP - Excel
gt;gt; Pearson Software Consulting, LLC
gt;gt; www.cpearson.com
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;CMIConniequot; gt; wrote in
gt;gt; message
gt;gt; ...
gt;gt; gt; Is there a way to DISABLE the shortcut key (ctrl D) which is
gt;gt; gt; Fill Down? I am
gt;gt; gt; needing to use ctrl F frequently and sometimes I accidently
gt;gt; gt; hit
gt;gt; gt; ctrl D and my
gt;gt; gt; spreadsheet is so huge that it locks up when I do that, then
gt;gt; gt; I
gt;gt; gt; loose all my
gt;gt; gt; changes. It takes a while to save, so it is impractical to
gt;gt; gt; save after ever
gt;gt; gt; change I make. Thanks for your time and any help you can
gt;gt; gt; suggest will be
gt;gt; gt; appreciated!
gt;gt;
gt;gt;
gt;gt;
It worked! Thank you! Thank you! Thank you!
I love learning something new. You just made my life easier!
Happy Easter...

quot;Chip Pearsonquot; wrote:

gt; In Excel, press ALT F11 to open the VBA Editor. There, go to the
gt; Insert menu and choose Module. Paste the code in that module.
gt; Then, close the VBA Editor to go back to Excel. Press ALT F8 to
gt; display the macro list. Select the macro to run and click the Run
gt; button.
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;CMIConniequot; gt; wrote in
gt; message
gt; ...
gt; gt; Thanks for your time answering my question... Would I run it as
gt; gt; a macro?
gt; gt; It's been 14 years since I've written macros and I know it is
gt; gt; different now...
gt; gt;
gt; gt; quot;Chip Pearsonquot; wrote:
gt; gt;
gt; gt;gt; You can do this with VBA code.
gt; gt;gt;
gt; gt;gt; Sub DisableCtrlD()
gt; gt;gt; Application.OnKey quot;^dquot;,quot;quot;
gt; gt;gt; End Sub
gt; gt;gt;
gt; gt;gt; Sub RestoreCtrlD()
gt; gt;gt; Application.OnKey quot;^dquot;
gt; gt;gt; End Sub
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Cordially,
gt; gt;gt; Chip Pearson
gt; gt;gt; Microsoft MVP - Excel
gt; gt;gt; Pearson Software Consulting, LLC
gt; gt;gt; www.cpearson.com
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;CMIConniequot; gt; wrote in
gt; gt;gt; message
gt; gt;gt; ...
gt; gt;gt; gt; Is there a way to DISABLE the shortcut key (ctrl D) which is
gt; gt;gt; gt; Fill Down? I am
gt; gt;gt; gt; needing to use ctrl F frequently and sometimes I accidently
gt; gt;gt; gt; hit
gt; gt;gt; gt; ctrl D and my
gt; gt;gt; gt; spreadsheet is so huge that it locks up when I do that, then
gt; gt;gt; gt; I
gt; gt;gt; gt; loose all my
gt; gt;gt; gt; changes. It takes a while to save, so it is impractical to
gt; gt;gt; gt; save after ever
gt; gt;gt; gt; change I make. Thanks for your time and any help you can
gt; gt;gt; gt; suggest will be
gt; gt;gt; gt; appreciated!
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;