Remove Password for Protected Sheet

How to unlock password protected sheets in OpenOffice Calc?

Explanation

To unlock the password protected sheet in a spreadsheet file do the following.
Step 1: Keep the password protected sheet as active sheet.
Step 2: Click Tools tab and select Protect Document -> "Sheet..."

Step 3: Unprotect sheet dialog box opens. Type the password under Password field and click OK.
Now the sheet will be unprotected and it wont ask for the password next time.

Related Topics