Super-hiding: Hide and lock sheets
Hiding sheets doesn’t mean they won’t be visible forever.
Other users who know how to unhide sheets in Excel can easily do it.
All they have to do is to right-click a sheet tab and click unhide. Like this 👇
The Unhide dialog box appears.
Then they’ll be able to see all the hidden sheets in the workbook and unhide worksheets 😩
You can prevent this by protecting your worksheet tabs 🔒
To completely lock a sheet for viewing, follow these steps:
- Right-click the sheet you want to protect (In our example, Data Source)
- Click Hide.
- In the Protect Group, select Protect Workbook.
The Protect Workbook dialog box appears.
- Type a password.
- Click OK.
- Confirm Password.
- Finally, click OK.
Now, when someone attempts to unhide worksheets, they can’t 😉
By protecting the workbook with a password, you lock the workbook structure.
This means that users can’t add, move, delete, or rename worksheets. They also can’t hide a sheet or unhide a sheet in the workbook 👍
Because these commands will now be unavailable for them.