Locking Timestamp

[curtjer]

Here is my equation for my timestamp

=IF(D2<>"",IF(A2="",NOW(),A2),"")

Whenever I type into field D2 it populates current date and time in field A2 and down the A column as I write into current D columns. The next step I would like to do in which he was able to figure out so far is how to lock in the date and time after something has been typed into D2. If I make any changes to the D2 field it updates the date and time, which I dont want to happen. Please let me know if anyone has a solution for locking original time stamp. Thank you.

[Everstrivin]

You could put this:

Please Login or Register  to view this content.

into the worksheet_calculate event.

i.e. go into VBE find the worksheet in the right hand window (Project Manager, i think) right click on the worksheet and choose view code. In the window that pops up, choose worksheet from the left hand drop down and calculate from the right hand drop down. You will have to modify the code to match your data.

[curtjer]

I'm sorry, i'm a novice at this, I dont understand what VBE is, could you explain?

[curtjer]

Hey, this works great if I dont delete the previous information in my cell that creates the timestamp. If I delete this it still refreshes the timestamp, but if I just edit current information without deleting it works great, let me know if you have a fix. Thank you.

[J_Alvarado]

I need help in locking my timestamed cells.
Column A is Name, Column B is X, Column C is formulated for Timestamp.
How do i lock. I do not want TS to be edited.

[FDibbins]

I need help in locking my timestamed cells.
Column A is Name, Column B is X, Column C is formulated for Timestamp.
How do i lock. I do not want TS to be edited.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread