Reply to thread

Message: [QUOTE="athi.sath, post: 14176582"] 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 [/QUOTE]