Stop Overwriting (Fill, Copy, etc) Data Validation

[Silena K-K]

Hi Everyone

How do I stop a user overwriting Data Validation rules with the Fill (down,
right, etc) command?

I have a macro set-up to prevent users from Cut/Copy/Paste and Cell Drag and
Drop but don't know what the code is for Fill.

Thank you, Silena

 

[Silena K-K]

I have all cells (excluding the data entry cells) protected but I am trying
to stop users using Fill in the data entry fields.

For example I have a heading title (in text, cell protected) in the cell
directly above my data entry cells (DV = decimals >0, cell unprotected).

If I select from the cell with the heading title and the data entry cells
below, and then select Fill, Down. The contents of the text cell overwrite
the data validation in the data entry cells.

Silena

 

[Gord Dibben]

When protecting the worksheet make sure you have deselected "locked cells"

Users can then not select the locked heading title cell in order to fill down.

Excel 2002 and newer supports this feature.


Gord Dibben MS Excel MVP