Disable control down (cntl D) on a worksheet

  • Thread starter Thread starter mcpheat
  • Start date Start date
M

mcpheat

Can you please help me with some code that can be entered into
a worksheet to "disable" a user doing a fill down with "control D".
It may be helpful to just disable control "a" to "z" so as to keep
control pageup/down still in operation.

I suspect it would go into the following private sub
Worksheet_Change(ByVal target As Excel.Range)


Thanks for your help.
Tony.
 
Look in Excel VBA help for the onkey command.

Change fires on each edit of a cell - there is probably a better event that
will fire less often and still accomplish what you want.
 
Back
Top