Circumventing Data Validation

[Jim & Gail]

Here's my dilemma...

B17 is formatted as General with no data validation settings.
C17 is formatted as Text, with a validation setting for text length between
5 and 40 characters.

Users are circumventing the validation in C17 by copying a three letter
entry from B17 and pasting it into C17. Not only is the entry accepted, but
C17's validation reverts back to "Allow any value."

Is there any way to "lock" the validation, so to speak?

Thanks,
Jim

 

[Frank Kabel]

Hi
if copying values is allowed no simple solution available for this. You
could create a macro (using the worksheet_change event) to check if
this cell is changed and re-apply the formats. Or just simply train
your users NOT to do this