Hide a worksheet and require password to unhide in excel
- how to lock unhide sheet in excel
- how to lock unhide in excel
- how to unhide password protected sheet in excel
- can you lock a hidden sheet in excel
How to protect excel sheet from editing and copying.
Unprotect excel workbook with password
It's difficult to make this tamper proof, but you could do the following. I'll use TopSecret as password.
Let's say you use C2 on the Overview sheet to enter the password.
1) Right-click the sheet tab of the Overview sheet.
Select 'View Code' from the context menu.
Copy the following code into the worksheet module:
2) Still in the Visual Basic Editor, double-click ThisWorkbook.
Copy the following code into the ThisWorkbook module:
3) Still in the Visual Basic Editor, select Tools > VBAProject Properties...
Activate the Protection tab.
Tick the check box 'Lock project for viewing'.
Enter a password in the password box, and re-enter it in the 'Confirm password' box.
Click OK.
4) Switch to Excel.
Save the workbook as a macro-enabled workbook (*.xlsm).
Close it.
When someone now opens the workbook, all sheets except Overview will be hidden, and the cannot be unhidden the usual way.
The Visual Basic code will be hidden, and the password entered under 3) will be needed to be able to view the code.
Warning: there are ways around this, but it should be sufficient t
- how to lock hidden sheets in excel
- how to lock and hide sheet in excel