PDA

View Full Version : Dynamic protection of data



Aussiebear
04-19-2008, 07:23 PM
In the attached workbook, I have a data table which when a value is entered in column C, an appropriate date & time Stamp is entered in Column D.

What I'm now chasing is a method to dynamicilly add protection so that once data is entered, it cannot be changed.

The data table is simply about recording who finished in what position in a tri-athletic event.

BTW: The intenationally recognised competitors ( firefytr, mdmackillop, xld, simon lloyd, & johnske) all competed on behalf of a number of charities they nominated and should be congratulated for their outstanding efforts.:devil2:

mikerickson
04-19-2008, 07:53 PM
One approach would be to set the .Locked property of a cell to True when the formatting is set.

Bob Phillips
04-19-2008, 10:00 PM
You could use data validation with a custom type and a formula of

=D2=""

BTW, 50km run and 120km bike is tough, but I would have no hope of doing a 15km swim.

Aussiebear
04-19-2008, 10:17 PM
Well you did walk it.....