| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
allow insert rows = false for only some of the worksheet
Hellow,
Lets say I have a file with data in 400 rows. I do not want to allow users to delete OR INSERT rows from 1 - 200. But from row 201 on they can do both. I have half of this figured out. I've locked cells 1 - 200 in an unused column before protecting. Users cannot delete these rows, but it does not keep them from adding new rows. I want full access to edit the data, so I cannot lock the cells in 1 - 200. Thank you in advance! -- BILL |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert rows in a worksheet that do not change adjoining rows | Excel Discussion (Misc queries) | |||
| How do I insert blank rows between rows in completed worksheet? | Excel Discussion (Misc queries) | |||
| How do I insert rows in more than one worksheet at a time? | Excel Worksheet Functions | |||
| how can I insert rows in part of worksheet | Excel Worksheet Functions | |||
| Protect Worksheet but allow to insert or delete rows | Excel Discussion (Misc queries) | |||
Threaded Mode
