protecting cell depending on value of another cell

[Janet Panighetti]

I tend to limit data entry on my worksheets by unchecking the "Lock" box
(Format Cells -> Protection -> then uncheck lock box) and then protecting the
sheet (Tools -> Protection -> Protect Sheet) with only "Select unlocked
cells" checked.

I am creating a worksheet where some of the cells require entry only if
there is a certain value in a certain cell. For example:

if J3="BLING" ... then Q13 is locked

if J3="CLATTER" ... then Q13 is unlocked

Is it possible to lock or unlock a cell automatically according to the value
of one of the cells on a worksheet?

Thanks in advance,
Janet

[Dave Peterson]

You might be able to use some sort of worksheet event (worksheet_change???) that
looks at changes in J3. If it finds a value, it unprotects the sheet, changes
the "lockedness" of another cell, the reprotects the worksheet.

You can read more about events at:
Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/event.htm

Janet Panighetti wrote:
>
> I tend to limit data entry on my worksheets by unchecking the "Lock" box
> (Format Cells -> Protection -> then uncheck lock box) and then protecting the
> sheet (Tools -> Protection -> Protect Sheet) with only "Select unlocked
> cells" checked.
>
> I am creating a worksheet where some of the cells require entry only if
> there is a certain value in a certain cell. For example:
>
> if J3="BLING" ... then Q13 is locked
>
> if J3="CLATTER" ... then Q13 is unlocked
>
> Is it possible to lock or unlock a cell automatically according to the value
> of one of the cells on a worksheet?
>
> Thanks in advance,
> Janet

--

Dave Peterson