Ken Johnson or someone! -- I need some help again!
Hi Fecozisk,
Sorry, I should've tidied it up a bit more..
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Range("E4:AT29,E66:AT91"), Target) Is Nothing Then
Exit Sub
End If
Me.Unprotect
Target.Locked = True
Me.Protect
End Sub
Ken Johnson
|