Unable to use data validation in protected sheet

Hi there,

You don't really need to lock the cells because you're effectively protecting them by applying validation to any value which the User enters.

Just unlock the cells using the FormatCells feature and remove the following line from your code:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Thanks Greg, it worked.

Hi again,

Many thanks for your feedback - I'm glad that I was able to help.

Regards,

Greg M