Password protection: Protecting and encrypting workbooks |
To disable/enable cell protection settings for a given worksheet, use the Tools > Cell Protection command. Your password must consist of at least 6 characters.
Once the cell protection is active, you can use the Format > Protected command to turn on/off the individual cell protection.
Protected cells can not be deleted.
Each time you (un-)protect some cell(s), you'll be asked to supply a password defined as explained above.
Note: Unless your workbook is encrypted at the same time, a person having full access to your file can use another software capable of reading/writing *.ods files to change this settings.