I have a Worksheet_change module on each sheet tab in a workbook that links
the sheet tab name to a specific cell on the worksheet. Here is the simple
code:

Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Name = Range("B2").Value
End Sub

The problem is that when the workbook is protected, users get this error
message when attempting to enter data into any of their "unprotected"
regions: "application-defined or object-defined error". The Debug button
goes to the Worksheet_change code--- which confuses me because they are not
entering into cell B2 (it is protected). I'll admit this code is new to me,
but what am I missing?