Data Validation Macro stops working when worksheet is protected

Please Login or Register  to view this content.

Hey guys, cross posting this from mrexcel http://www.mrexcel.com/forum/excel-q...protected.html.

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.

Actually I did it with the following code and everything works well, I cannot Copy and Paste into Column B even after the worksheet is protected:

Please Login or Register  to view this content.

It tells me "You must choose a valid response from the DropDown" or if I add something like A (my DV was 1,2,3) it ...."Value ...is not valid "

I've tried creating a blank spreadsheet, locking only the header row, and it still always comes back true for me. Using excel 2010.

Could you upload a workseet example?

Upload Book.xlsm

Here is a quick test book I created.

Try this for now...

In module:

Please Login or Register  to view this content.

Unloack your Cells In column A that will have Validation and change your code in sheet to:

Please Login or Register  to view this content.

Let me know if it does something

Nope just tested it