"Gareth - Network analyst." wrote:



"Paul Lautman" wrote:

Ken Johnson wrote:

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...
Not if you format C2 to have the same colour text as background or give it a
font seting of wingdings.

Ok that Works But one little problem that i found here now...
OK so C2 my password cell is the same color as the background and is locked
to the font i set. now in D2 i got the Validation running stating EG.
=OR($C$2="password"). ok no problem

BUT now i have a cell D3 that has a Vlookup dependent on the cell value in
D2 i just tested it if i enter this lookup value say D3 is
=VLOOKUP(C3,Passwords!A:L,2,FALSE) the Value in the look up will display with
the error for invalid password......

How do i bypass this.


Bingo I worked it out... Just for added Security you also add the If
Statment into my D3 cell it looks like this.
=IF(C2="password",(VLOOKUP(C3,Passwords!A:L,2,FALS E)),"#N/A")
Actually works a bit better than the Validation lookup... you just add the
Validation for Extra protection.

Thanks all for the assist and the suggestions. :-)