Auto Lock after first Data Entry and Time Stamp

Hi all,

I just registered but have been a long time reader of the forum. I would like some help regarding a spreadsheet that I am currently trying to program.

It goes something like this:


Row Column C Column D Column E
2 Tom Dave Bob
3 Approved Not Approved Amended
4 Time & Date Time & Date Time & Date


• C2, D2 and E2 are names of Employees. Tom can only change C3 and C4. He cannot change anything in D3, D4, E3 and E4. Similarly, Dave and Bob can only change their own respective column values.
• C3, D3 and E3 - each have Data Validation Lists with drop down options Appoved, Not Approved and Amended.
• C4, D4 and E4 have the following formulas:

=IF($C$3<>"",IF(C4="",NOW(),C4),"")
=IF($D$3<>"",IF(D4="",NOW(),D4),"")
=IF($E$3<>"",IF(E4="",NOW(),E4),"")

As soon as value was entered in Cell C3, C4 shows the time and date. Same goes for E3, E4 and D3, D4.

My question is, now that any value is selected in cell C3 (e.g. Approved), I would like it to be automatically locked and no one else can change it (even Tom, who originally approved it).

Any suggestions would be welcome,

Thanks,

Dear mehmetcik,

THANK YOU SO MUCH. It works like a charm. If I ever get a chance, I would like to shake hands with you. You made me look like a rockstar in front of my manager.

Best regards,
mac