Lock cells based on other cell value

[TheWennerWoman]

Hello,

I have this

Private Sub Worksheet_Change(ByVal Target As Range)

If Range("C7") = "No" Then
Range("C8").Locked = True
ElseIf Range("C7") = "Yes" Or Range("C7") = "<Select>" Then
Range("C8").Locked = False
End If
End Sub

This is erroring with "Unable to set the Locked Property of the Range Class"?

Any thoughts? Range C7 is a drop down box (using data validation) if that makes any difference?

Thank you for reading.

 

[TheWennerWoman]

Ok, sorted it, I had merged cells.