| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet Restrictions
Is it possible to restrict the adding on of extra lines to a sheet
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sheet Restrictions
At the simplest you could protect the sheet using tools - protection but this
could be a problem if you want to do other things. Can you be more specific. "Office Jnr" wrote: Is it possible to restrict the adding on of extra lines to a sheet |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sheet Restrictions
Thanks Mike that is tru. I want the cell contents to be capable of being
changed. I want to copy several sheets that are updated independently by various people to a file that is under my control - monthly. I then want to be able to pick up certain defined cells from these added sheets without doing the lookup every mnth. So if I copiend and pasted the files in exactly the same position it would bring back the contents of the same cells. "Mike" wrote: At the simplest you could protect the sheet using tools - protection but this could be a problem if you want to do other things. Can you be more specific. "Office Jnr" wrote: Is it possible to restrict the adding on of extra lines to a sheet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Rename Excel Sheets in Workbook | Excel Worksheet Functions | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Linear Mode
