JLGWhiz napisal(a):
Did you attempt to save the changes you made with the protection on? You
will probably find that you cannot.



I did. As I remember I saved the changes. If you have spare time you
can try to my code to new sheet and test. Everything looks fine except
the code is not working.

I also noticed that sometimes when I tried to copy the code to new
sheet it becomes unstable. Macro was doing something till Ctrl+Break
was hit. (on unprotected sheet) and eventually I cut off the code
although I think the idea of the code is very good (I don't know other
protection for validation data in the cell)

Regards
PAT