| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to protect a range
Hi,
Is there a way to protect a range in a worksheet, without protecting the entire range? Thanks for your help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to protect a range
Hi Jeff,
by default all cells are locked, what you could do it selecte entire ws, FORMAT | CELL | PROTECTION | uncheck LOCKED Than select just the range that you are thinking to protect and locked the cells, protect the ws HTH Regards from Brazil - going to the 6th * Marcelo "Jeff" escreveu: Hi, Is there a way to protect a range in a worksheet, without protecting the entire range? Thanks for your help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to protect a range
Hello,
If I protect a range of cell, people won't be able to insert any rows within the range. I would like to know if there is a way to allow people to insert row when cells are protected. Thanks! Alex "Marcelo" wrote: Hi Jeff, by default all cells are locked, what you could do it selecte entire ws, FORMAT | CELL | PROTECTION | uncheck LOCKED Than select just the range that you are thinking to protect and locked the cells, protect the ws HTH Regards from Brazil - going to the 6th * Marcelo "Jeff" escreveu: Hi, Is there a way to protect a range in a worksheet, without protecting the entire range? Thanks for your help |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to protect a range
If you're using xl2002 or higher, you can protect the sheet and still allow the
user to insert rows. Alex wrote: Hello, If I protect a range of cell, people won't be able to insert any rows within the range. I would like to know if there is a way to allow people to insert row when cells are protected. Thanks! Alex "Marcelo" wrote: Hi Jeff, by default all cells are locked, what you could do it selecte entire ws, FORMAT | CELL | PROTECTION | uncheck LOCKED Than select just the range that you are thinking to protect and locked the cells, protect the ws HTH Regards from Brazil - going to the 6th * Marcelo "Jeff" escreveu: Hi, Is there a way to protect a range in a worksheet, without protecting the entire range? Thanks for your help -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
| How do you Identify text as a named range in excel | Excel Discussion (Misc queries) | |||
| VLookup Error in Part of a Named Range | Excel Worksheet Functions | |||
| UDF is updateing cells on another sheet with count from current sheet. | Excel Discussion (Misc queries) | |||
| FORMULA at Source range (in Data-validation-List) gives wrong re | Excel Worksheet Functions | |||
Hybrid Mode
