Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell protection, how to?
How do I protect selected cells for protection in a worksheet?
I have gone to tools and protection but can only seem to protect the full worksheet, I have tried clicking/unclicking locked and unlocked boxes but cant seem to get it right. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell protection, how to?
Sun, 17 Jun 2007 10:16:27 GMT from S S :
How do I protect selected cells for protection in a worksheet? I have gone to tools and protection but can only seem to protect the full worksheet, I have tried clicking/unclicking locked and unlocked boxes but cant seem to get it right. There are two layers, cell protection and worksheet protection. By default every cell is protected but the protection is switched off for the worksheet as a whole. To protect specific cells you need to change both those layers, in sequence: 1. Unprotect the cells you don't want to protect (Format | Cells | Protection). 2. Turn on the protection system with Tools | Protection | Protect Worksheet. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell protection, how to?
Try it in this sequence ..
First, you need to "unlock" all cells in the sheet. Select the entire sheet, click Format Cells Protection tab Uncheck "Locked" OK. Now select only the cells that you want protected (Hold down CTRL to select multiple cells/ranges). Click Format Cells Protection tab Check "Locked" OK. Then apply sheet protection via Tools Protection Protect Sheet Password? OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "S S" wrote: How do I protect selected cells for protection in a worksheet? I have gone to tools and protection but can only seem to protect the full worksheet, I have tried clicking/unclicking locked and unlocked boxes but cant seem to get it right. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
*****Cell Protection***** | Excel Discussion (Misc queries) | |||
cell protection | Excel Worksheet Functions | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
CELL PROTECTION | Excel Worksheet Functions | |||
Cell protection | Excel Discussion (Misc queries) |