How-To: Protect Sheet - OpenOffice.org Calc
- To protect a sheet, click on the "Tools" menu.
- Select the "Protect Document" item from the menu.
- Select the "Sheet..." item from the sub menu.
- The "Protect Sheet" dialog appears.
- Click in the "Password" field and type a password.
- Click in the "Confirm" field and repeat the same password.
- To finish the dialog, click the "OK" button.
- Notice that protecting the sheet will only protect cells that are formatted as protected.
- Also, notice that only direct changes are prohibited. Changes of value resulting from dependencies on other cells are still possible.
- Attempts to directly change a protected cell in a protected sheet will result in a Warning message.
powered by Plan-B screencast technology
Protect Sheet
This screencast demonstrates how to protect
sheet
against unauthorized changes in OpenOffice.org Calc.
You learn:
- How to navigate to the "Sheet Protect" dialog.
- How to enter the password to release the protection.
Notice that protecting the sheet only protects against changes of protected
cells.
Notice further that a cell is only protected against direct changes of
its value or
formula.
Advanced topics
For advanced functionality with similar results see:
OpenOffice.org™ is a trademark of OpenOffice.org.
