Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Protection Issue
Dear All,
I am looking to protect my formula's from accidentally being typed over. I know that there is the protection, Locked function, but was wondering whether there is a way to lock some cells completely, and lock others so that they can be selected but not edited? Thanks in advance!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Protection Issue
If you lock a cell (Format|cells|protection tab), then protect the worksheet
(tools|protection|Protect sheet), the cell can still be selected, but not changed. Did it not work for you? Sukh wrote: Dear All, I am looking to protect my formula's from accidentally being typed over. I know that there is the protection, Locked function, but was wondering whether there is a way to lock some cells completely, and lock others so that they can be selected but not edited? Thanks in advance!! -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Protection Issue
Remember that the Locked status doesn't take effect until the worksheet is
put into Protected state: Tools | Protection | Protect Sheet In Excel 2003, at that point you have the option to permit users to select locked cells or not. Selecting a Locked cell on a protected sheet just means that they can click on it and have it selected, they just can't edit or alter it. The default is that they can select Locked cells, which as I said, still doesn't allow them to change what is in them. On a protected sheet, the only cells they can type information into or copy from are those you have specifically removed the Locked attribute from using Format | Cells | [Protection] and cleared the Locked checkbox for. "Sukh" wrote: Dear All, I am looking to protect my formula's from accidentally being typed over. I know that there is the protection, Locked function, but was wondering whether there is a way to lock some cells completely, and lock others so that they can be selected but not edited? Thanks in advance!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Cell Protection Issue | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |