Quote:
Originally Posted by Spencer101
|
I have been using the below mentioned VBA code for cell protection,
It is protected only "A2" We need to protect from A2 to A8, Pls help me.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address < "$A$2" Then Exit Sub
Application.EnableEvents = False
MsgBox "Hey, leave me alone!"
Application.Undo
Application.EnableEvents = True
End Sub