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

 

[HKaplan]

Have you tried protecting the cell? Tools|Protection|Protect
Worksheet.

By default all cells are protected.(locked), so you would need to
unlock all cells then lock the ones you don't want to change. Right
Click - Format Cells - Protection Tab.

 

[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