Hello,Hoping someone may be able to help please.I have 20 odd worksheets all relating to different companies.I need to know when the last update on individual worksheets was.I have used the below code - but this won't work as I have the worksheets protected so people can only add into specific cells. How can I enable the update but still keep the locked cells protected?Many thanks, H. Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("C5:E164")) Is Nothing Then Range("D3") = Format(Now, "mm/dd/yyyy h:mm") End IfEnd Sub