Unprotecting the worksheet

If the worksheet is password protected, specify the password and click OK. The worksheet is now unprotected and the password is removed. You can also specify a different password or choose to use no password if you want to protect the worksheet again.

An alternate method is to select Tools > Protection > Unprotect Sheet.