I have a set of questionnaire form...
if A1="No" then disable/lock B1
if A2="No" then disable/lock B2
etc

if A1 is Yes then you can (enable/unlock) B1 and can accept values etc

can not seem to lock and protect the worksheet to do what I want....
I have been using worksheet change event....

I tried ....
Sheets("xxxx").range("A1:B39").Locked = False
Sheets("xxxx").protect

I then try and set specific cells to be locked = true
i.e
if range("A1")="No" then range("B1").locked = true
else range("B1").locked = False
end if


however this approach is not working....
can you suggest the best way to achieve my goal...
disable/enable or lock/unlock hide/unhide B1 dependent on A1
disable/enable or lock/unlock hide/unhide B2 dependent on A2