TheWennerWoman
Active Member
- Joined
- Aug 1, 2019
- Messages
- 270
- Office Version
- 365
- Platform
- Windows
Hello,
I have this
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.
I have this
VBA Code:
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.