Hey guys, cross posting this from mrexcel http://www.mrexcel.com/forum/excel-q...protected.html.Please Login or Register to view this content.
I found this simple sub/function that does not allow users to paste invalid data over a cell with data validation. It works fine until I protect the worksheet. Once it's protected the function always returns a value of "true" and doesn't function correctly.
Bookmarks