Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can some cells remain unprotected in a protected spreadsheet ?
I know that Lotus allows for spreadsheet protection, allowing the user to
unprotect specific cells, thus protecting against overwriting a formula while entering variables into the spreadsheet. An example may be an amortization schedule, containing formula to be protected, while allowing the term, rate, and amount fields to be accessed? Can anyone help or do I have to use Lotus !!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can some cells remain unprotected in a protected spreadsheet ?
Yes, check out help for sheet protection. I think its pretty well explained
HTH Regards, Howard "Detenbeck3890" wrote in message ... I know that Lotus allows for spreadsheet protection, allowing the user to unprotect specific cells, thus protecting against overwriting a formula while entering variables into the spreadsheet. An example may be an amortization schedule, containing formula to be protected, while allowing the term, rate, and amount fields to be accessed? Can anyone help or do I have to use Lotus !!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can some cells remain unprotected in a protected spreadsheet ?
Select the cells you do not want protected. Then: - Format - Cells - Protection tab - Unclick the "Locked" checkbox -- LACA ------------------------------------------------------------------------ LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381 View this thread: http://www.excelforum.com/showthread...hreadid=500456 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Spreadsheet won't let me merge cells. plse help. | Excel Discussion (Misc queries) | |||
Formatting on unprotected cells | Excel Discussion (Misc queries) | |||
How do I show protected cells in an EXCEL worksheet | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |