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
!!!

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
!!!

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