Re: Cell locking dependent on Cell value




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.

Thanks for that Paul.
Very niffty solution.
Ken Johnson

.



Relevant Pages

  • Re: Word 2007 : save as type "Word97 - 2003" doesnt woerk
    ... I think the problem is "by accepting all changes and ... removing all comments". ... Some of them don't like PDF format. ... Track changes settings do not travel with the document. ...
    (microsoft.public.word.docmanagement)
  • Re: Sending a odt file format to windows user
    ... They made a big song and dance about accepting more ... open standards, but since then they have come up with formats that are ... only format accepted by both the ISO and the EEC, ... and how explain that Microsoft want Windows users ...
    (Ubuntu)
  • Re: How to accept date in particular format
    ... >I am looking for accepting a date in format mm/dd/yyyy. ... in locales/countries, is to have 3 fields, properly identified as day, ...
    (comp.lang.cobol)
  • How to accept date in particular format
    ... I am looking for accepting a date in format mm/dd/yyyy. ... is a newbie question. ...
    (comp.lang.cobol)
  • Re: French numeric formats
    ... Without changing the language settings, I was able to get it with a custom ... > space seperator, but is not accepting the brackets as an available option, ...
    (microsoft.public.excel.misc)