How to Unhide Very Hidden Worksheets in Excel

1. Press Alt + F11 to open the Visual Basic Editor.
2. In the VBAProject window, select the worksheet you want to unhide.
3. In the Properties window, set the Visible property to -1 – xlSheetVisible.

How to unlock hidden worksheets in Excel?

hidden

1. To hide a sheet, just right-click on the sheet’s tab and select Hide. …
2. To unhide a sheet, just right-click on any sheet’s tab and select Unhide. …
3. Select Hidden Sheets and click OK. …
4. The top left panel is the Project Explorer, where you can use the tree to navigate to any open workbook and any worksheet.

Why is unhide grayed out in Excel?

If both the Ribbon and the « Unhide » command in the right-click menu are greyed out, it means you don’t have a single hidden sheet in your workbook 🙂 That’s it you unhide Worksheets in Excel.

How to prevent Excel from unhiding?

Tricks to hide worksheets (not easy to unhide) without protecting the workbook

1. Right click on the sheet to hide.
2. Click to view the code.
3. Scroll down to Worksheet Properties in the VBA window.
4. Select Very Hidden in the Visible drop-down list.
5. This will ensure that when someone tries to unhide the worksheet in Excel, the unhide option is grayed out.

3 Ways to Unhide All Worksheets in Excel (and How to Hide)

43 related questions found