Password Protect Unhide Worksheet Excel 2007. Be sure to remember the password or store it in a safe location because you will need it If the worksheet was not protected with password, clicking the Unprotect Sheet button is all it takes to unlock the sheet. Request to you please do help me out.
Protecting worksheet elements should not be confused with workbook-level password security, which prevents users from opening a file at all. This video shows how to save a workbook or worksheet as a password protected file. I have an Excel file with a macro to unhide certain worksheets when the user clicks a button.
But, it's easy to forget or misplace your passwords.
Now if all your attempts till now have been.
The file will require a password to be entered in order to open or view. The Protect Sheet menu lets you refine the options for sheet protection. It is not recommended if you are not familiar.