Unlock Locked/Protected Cell based on text from another Cell

[kiwikiki718]

I Currently trying to write a code that will unlock a locked/procted cell based on data entered in another cell. below is the formula that I currently have.



Private Sub Worksheet_Change(ByVal Target As Range)
IfRange("C10") = "Other" Then
Range("D10").Locked = False
ElseIfRange("C10") = "" Then
Range("D10").Locked = True
End If
End Sub