Morning,

I have a request log with data that needs to be protected once entered as it is 'signed off' so must not be able to be changed once signed.

Is anyone able to offer some coding that looks to check that once 'signed' the data in the cells of that row cannot be edited and/or a message box pops up advising unable to edit?

I have used various codes below to get parts of what I want but nothing to check against the signature cell?

Message Box:

If Intersect(Target, Range("Data")) Is Nothing Then Exit Sub
    If ActiveCell > 0 Then
        MsgBox "Already Submitted", vbInformation, "Error"
        Cancel = True
    End If
Locking cells/sheet:

Call Protect
Any help would be great!

many thanks