Locking records once "closed"

[Pascale]

The user is selects their name from a drop down menu. When the cell e
X1 is filled the completed date is automaticallly entered based o
if(X1<>"",NOW(),"").

After this happens I would like to change the formula cell to a date
so that it will not change everytime the worksheet is opened. How do
achieve this without using VB.


Is it possible to protect cells once X1<>"", or better yet change al
dates on that row to lock.


Or is there another method of achieving the same objective. That i
once a record is complete no further changes cand be made.


Thanks in advanc

 

[JulieD]

Hi Pascale

you said: "I would like to change the formula cell to a date, so that it
will not change everytime the worksheet is opened. How do I
achieve this without using VB."

well AFAIK you can't do it without VBA ...any reason why you don't want a
code solution?

Cheers
JulieD

 

[CLR]

Maybe try Copy > Paste special > Values..............to another cell, or
back on that one itself.

Vaya con Dios,
Chuck, CABGx3