Can some cells remain unprotected in a protected spreadsheet ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
!!!
 
Yes, check out help for sheet protection. I think its pretty well explained

HTH
Regards,
Howard
 
Select the cells you do not want protected.

Then:

- Format
- Cells
- Protection tab
- Unclick the "Locked" checkbox
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refreshing Pivot Table on a protected spreadsheet tab 1
Using a variable spreadsheet reference in a formula 6
Unprotect Combo Box in a Protected Sheet 3
PROTECTING/UNPROTECTING SHEETS 1
Missing "Unprotect Workbook" option 4
Protection on Worksheets 5
Can I protect data in a cell, but allow comments to be entered. 6
Unprotect/Unlock Option B uttons 2

Back
Top