The intersect function will check if the row a user want to delete INTERSECT your range A5:D8. If so, it will end the Sub. You can also prompt the user with a message telling not to delete this row. I'll leave this to you.
Sub delete()
ActiveSheet.Unprotect
Dim a As Long, response As Long, asd As Range
a = Application.InputBox( _
Prompt:="Row-number", _
Title:="Delete row:", Type:=1)
If a <> False Then
response = MsgBox("Are u sure u wanna delete row", vbYesNo)
If Not Intersect(Rows(a), Range("a5:d8")) Is Nothing Then Exit Sub
If response = vbYes Then Rows(a).delete
End If
ActiveSheet.Protect
End Sub
Bookmarks