Gareth - Network analyst. wrote:
Hi Guys I always seem to have questions that are complex...

What im looking to do On a standard sheet Various cells. can i have a cell
that will not allow you to edit it unless another cell value is a spcified
Value.. basically a password thing.... what i am doing is this.

I have a Sheet whete cell C2 is where i want the user to enter a password
from several or even just one that i have defined. should that cell have the
correct value then cell D2 will allow you to edit its value. else the cell
should be locked for editing... is this possable? and how would i do it....
and please tell me you can do it without VB scripting.

Hi Gareth

Would Custom Data Validation be good enough. The Password in C2 will
always be visible in C2 while D2 is accepting the user's changes
though...

Select D2| Go Data|Validation|Select Custom from the bottom of the list
of types of validation|deselect "Ignore Blanks"| type in the formula...
=OR($C$2="Password1",$C$2="Password2",$C$2="Passwo rd3")

where Password1, Password2, Password3 are three passwords that you
would accept.

You can also add a message requesting the password be entered first.

D2 is editable, however the added change is not accepted without an
acceptable password in C2.


Ken Johnson