VBA to change cell from "Locked" to "Unlocked" based on another cell input

[CaptBrownShoes]

Would like to unlock a cell to allow input ONLY when another cell has the met criteria.

Current State:
Protected Sheet with no password
Cell L11 is "Locked"


Desired Outcome:
I want to unlock cell L11 when someone enters "Yes" in Cell O10

 

[mumps]

This macro assumes that cell O10 is unlocked. Copy and paste the macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Enter "Yes' In O10 and press the ENTER key.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.CountLarge > 1 Then Exit Sub
    If Intersect(Target, Range("O10")) Is Nothing Then Exit Sub
    If Target = "Yes" Then
        With ActiveSheet
            .Unprotect
            .Range("L11").Locked = False
            .Protect
        End With
    End If
End Sub

 

[propolis]

Can I just ask if the above has worked as I can't get it to work

Propolis