Hi,

I have a small piece of VBA which adds custom data validation on certain cells in my worksheet. These cells are not locked or hidden but when I protect the worksheet, this code does not work.

There does not appear to be any options to allow this code to work when I protect the sheet and I do not have a password on it.

Has anyone encountered this before? Could someone point me in the right direction?

Many thanks