Locking a cell based on tick box

[MissingInAction]

Good day everyone. I'm looking for VBA code that would lock a cell based on whether a check box has a tick in it, or not.
I have linked the check box to block G58. This block displays TRUE when the box is ticked. I then want block D59 to be unlocked if G58 is true and locked if G58 is false. I have tried the following code, but it does nothing:

    If Target.Address = "$E$55" Then
        If ActiveSheet.Range("G58").Value = True Then
            ActiveSheet.Unprotect
            Application.ScreenUpdating = False
            Range("D59").Select
            Selection.Locked = False
            Selection.FormulaHidden = False
        Else
            ActiveSheet.Unprotect
            Application.ScreenUpdating = False
            Range("D59").Select
            Selection.Locked = True
            Selection.FormulaHidden = False
        End If
    End If

E55 has a yes/no dropdown where the employee must select "yes" in order for the tick box to appear, which is why I used the if Target.Address code.

Thank you in advance.

 

[MissingInAction]

Bump. Anyone able to assist with this, or have a workaround that I can use please?

 

[MissingInAction]

The block in question (D59) has a yellow fill color, since it has a conditional format formula that will make it yellow if it is blank. I tried the following:

    If Range("D59:E59").DisplayFormat.Interior.Color = 65535 Then
        ActiveSheet.Unprotect "abc123"
        Application.ScreenUpdating = False
        Range("D59").Select
        Selection.Locked = False
        Selection.FormulaHidden = False
    Else
        ActiveSheet.Unprotect "abc123"
        Application.ScreenUpdating = False
        Range("D59").Select
        Selection.Locked = True
        Selection.FormulaHidden = False
    End If

The issue with this code is, it only triggers when the cell modified. This in turn also causes the person to be unable to modify what he entered, since any value inside that cell will remove the yellow fill, which means this idea wont work.