NickHK napisal(a):
You need to unlock some cells so the user is able to change some values and
trigger the _Change event.
Or you mean the event is firing, but the code errors ?

Also, do you not mean :
If HasValidation(Range("E2:E1001")) = True Or ...
instead of False ?

NickHK



I did. Like I said before when sheet is unprotected the code is working
perfectly. If I try to paste to cell from range and that would damage
the validation data it does Undo and inform me with msgbox. When I
protect the sheet it just stop working. No errors , nothing I just
paste data and destroy validation rules form cell without warning. I
tried unlock all cels from sheet then protect sheets and it gives me
nothing. From some reason protection just turn off the code.

PAT