Unprotect Worksheet Forgot Password. But, it's easy to forget or misplace your passwords. Recover a password to open a workbook or worksheet.
On the Review tab, in the Changes group, click Unprotect Sheet. Right-click the sheet tab, and select Unprotect Sheet… from the context menu. Recover a password to open a workbook or worksheet.
When password protect a Worksheet, you can edit the data on it anymore, unless unprotect it again.
It is an update to an earlier article where we discussed how you may be able to unprotect an Excel spreadsheet if you have forgotten the password used to protect it.
Enter the generated code as the password and your done. Sub PasswordBreaker() 'Breaks worksheet password protection. Unprotect "Password" I've forgot password in my worksheet,how to unprotect the sheet?