Lock / Unlock cells depending on True / False

[tlc53]

Hi there,

I'm not sure why this code isn't working. Can someone tell me if I'm missing a trick please?

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A17") = "TRUE" Then
Range("F17:K17").Locked = False
ElseIf Range("A17") = "FALSE" Then
Range("F17:K17").Locked = True
End If
End Sub

Thank you!

 

[tlc53]

So now I'm stuck on the data validation formula
Currently when check box is selected A17 return TRUE and the period ending date shows up in C17. When selected, they can enter data in that row (E17:H17, J17). However, if they have not selected the check box, I want data validation to return an error if they start enter data in that row (cell E17 for example).
So I put this code in Custom Data Validation: IF(AND(A17=False,E17<>0)
I wrote an error message. However, this isn't working, as regardless of whether A17 = True or False, it won't let me enter data in E17 and comes up with the error message. Any idea please Fluff?

 

[Fluff]

Just use =A17=TRUE

 

[tlc53]

Hehe.. brilliant, thanks!

 

[Fluff]

You're welcome