You stated that
In which case none of those selection will make a difference, but you now say
In which case the sheet is protected.
After unlocking all cells, select range C33:F52 & make them locked, then no one can enter data into them.
Well,
Sheet is protected form "Insert Column ,Insert Rows, Delete Column, Delete Rows.
Sheet is unprotected for entering data in any cells, so then it is involved VBA Code to keep clear range "C33:F52": only if Sheet/Tab name is "MASTER"
VBA:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("C33:F52")) Is Nothing Then
If ActiveSheet.Name = "MASTER" Then
cng = Target.Value
Application.Undo
Target.Value = Target.Value
Else
End If
End If
Application.EnableEvents = True
End Sub
-----------------------------------------------------------
Also there is second macro to prevent tab/sheet changing name: It keeps Tab name MASTER:
VBA
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Sheet1.Name <> "MASTER" Then
Sheet1.Name = "MASTER"
End If
End Sub
