| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Not allow data to be entered beyond a specified row.
Mike -
Thanks much. That did it! -- Cassie "Mike H" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Range updating automatically as new data is entered | Charts and Charting in Excel | |||
| the value of a box in excel if entered data is a certain value | Excel Worksheet Functions | |||
| ?-Change data series range as data is entered? | Charts and Charting in Excel | |||
| Why won't my newly entered data sort with old data ? | Excel Discussion (Misc queries) | |||
| Why won't my newly entered data sort with old data ? | Excel Discussion (Misc queries) | |||
Threaded Mode
