Lock/unlock/color a Range based on the Value in another Range

Hello,
My questions relate to Excel for MAC 2011 (not PC), I am very new at VBA. I found the below code and need help to make it work.

My Excel VBE wants to name the Routine in the format: SUB Name(). But I see many examples with "Private Sub Worksheet_Change(ByVal Target As Range)" which my Excel will not accept as a name.

But it is seemingly used as a name in all the examples I find. What is the issue here?

I have an old version of the book Excel VBA for Dummies and I can get one of his tutorial routines to work - it uses the SUB Name () format.

Any recommendation for a current book that addresses Excel for MAC 2011?

Once I get this working, I also want to change the "B1" Range cell colors based on the Value in "A1": It must run whenever the Workbook is open.

If Range("A1").Value = 1 Then
.Range("B1").Locked = False
ElseIf
.Range("B1").Locked = True
End If

End Sub

Help would be very much appreciated!