H
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 3 Or Target.Count > 1 Then Exit Sub
Target.Offset(, -2) = WorksheetFunction.Max([A:A]) + 1
Target.Offset(, -1) = Now
ActiveSheet.Unprotect "GPE"
Intersect(UsedRange, Target.EntireRow).Locked = True
Intersect(UsedRange, Target.EntireRow).Borders.LineStyle = 1
Target.Offset(, -1).NumberFormat = "dd-MMM-yy HH:mm:ss"
ActiveSheet.Protect "GPE"
End Sub
If Target.Column <> 3 Or Target.Count > 1 Then Exit Sub
Target.Offset(, -2) = WorksheetFunction.Max([A:A]) + 1
Target.Offset(, -1) = Now
ActiveSheet.Unprotect "GPE"
Intersect(UsedRange, Target.EntireRow).Locked = True
Intersect(UsedRange, Target.EntireRow).Borders.LineStyle = 1
Target.Offset(, -1).NumberFormat = "dd-MMM-yy HH:mm:ss"
ActiveSheet.Protect "GPE"
End Sub