Is it possible to lock the cells with conditio. I want to lock all the cells
after one week from the certain date on the sheet.

for Ex. $A$23 cell have the date 15 Aug 2005 and i want to lock the cell
$C$8 to $H$23 after one week from that date. so that no one can change the
data.

Thanks in advance

By default all cells are locked. You would need to unlock all desired and
then have a macro to lock the desired cells.
Sub lockcells()
Range("b1:d12").Locked = False
If Date Range("a4") + 15 Then Range("b1:b4").Locked = True
End Sub


--
Don Guillett
SalesAid Software

"Deepwater" wrote in message
...
Is it possible to lock the cells with conditio. I want to lock all the
cells
after one week from the certain date on the sheet.

for Ex. $A$23 cell have the date 15 Aug 2005 and i want to lock the cell
$C$8 to $H$23 after one week from that date. so that no one can change the
data.

Thanks in advance

Hi
Using Data/Validation menu, select the cells to be locked and choose in the
validation dialog box Allow: Custom with the following formula:
=TODAY()<=$A$23+7
and don't select Ignore blank.
As long as you're not a week after the date in A23, the user can enter what
he or she wants but after this date, the selected cells are not anymore
modifiable.
uh... Am I clear enough? I wonder... anyway, don't hesitate to ask more
details...
--
A+

V.


"Deepwater" wrote:

Is it possible to lock the cells with conditio. I want to lock all the cells
after one week from the certain date on the sheet.

for Ex. $A$23 cell have the date 15 Aug 2005 and i want to lock the cell
$C$8 to $H$23 after one week from that date. so that no one can change the
data.

Thanks in advance