Hi this code is from Tom (I think)
This code protect A1 cell, I want to know how I can protect let's say A1 to A70 and B50 to B70 without doing this code for every single cell.
This code protect A1 cell, I want to know how I can protect let's say A1 to A70 and B50 to B70 without doing this code for every single cell.
Code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address <> "$A$1" Then Exit Sub
Application.EnableEvents = False
MsgBox ("Hey, leave me alone!")
Application.Undo
Application.EnableEvents = True
End Sub