Data Validation

[JPDS]

Does anyone know how to protect cells which have data validation in them? I'm
using the general protection methods which doesnt seem to work.

 

[Bob Phillips]

Protecting them from what?

 

[Shane Devenshire]

Hi,

If you are choosing Tools, Protection, Protect Sheet your Data Validations
are protected provided the Format, Cells, Protection option is set to Locked.

 

[JPDS]

Hi,

It does and it doesnt really - I have a table of 5 columns all dates. Date1
is a validation list based on a set of dates. Date2 is offset against the
dates in Date1 i.e. Date2 can never occur before Date1 etc, up to Date 5.
When I protect the cells etc, the process works i.e. you can only choose from
the validation dropdown lists so long as you choose Date1, then Date2 then
Date3 etc. If you skip Date3 then enter data into Date4 manually, this is
accepted. And thats my problem, I only want people to choose from the
dropdownlists. Does that make sense?

 

[Gord Dibben]

Doable with event code to unprotect the sheet and unlock a cell for entry if
the entry meets your condition.

Else, keep sheet and cell locked so user cannot enter an invalid date
manually.

Two questions..........which cell or cells have the dropdown list(s) with
Date1, Date2 etc.?

Which are the five columns with the dates?


Gord Dibben MS Excel MVP

 

[JPDS]

Column1 = Date1 = validation list from an array of any dates
Column2 = Date2 = Offset validation list against Date1 (Date2 is never
before Date1)
Column3 = Date3 = Offset validation list against Date2 (Date3 is never
before Date2)
Column4 = Date4 = Offset validation list against Date3 (Date4 is never
before Date3)
Column5 = Date5 = Offset validation list against Date4 (Date5 is never
before Date4).

The sequence always starts with choosing Date1 from the list, however it is
possible to miss Date2 then manually key into Date3.