Cassie,

Right click your worksheet tab, view code and paste this in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 201 Then
Application.EnableEvents = False
MsgBox "Not allowed"
Application.Undo
Application.EnableEvents = True
End If
End Sub

Mike

"Cassie" wrote:

How do I format the spreadsheet to not allow data to be entered beyond a
specified row. I have a spreadsheet that I don't want data entered below row
201. I haven't been able to find this on any of the help searches.
--
Cassie