Very Hidden Worksheet in Excel

A very hidden worksheet is a sheet that won’t be displayed in Excel interface. Unlike proper hidden worksheet, a very hidden worksheet isn’t showed in unhide selection dialog box. How to make a very hidden worksheet:

1. Open the workbook (excel file)
2. Open Visual Basic editor by pressing Alt + F11
3. If Project Explorer and Properties not showed, press Ctrl + R then F4 to activate
4. Select worksheet you want to hide in Project Explorer then go to Properties, look for item Visible, change the value to 2 – xlSheetVeryHidden.
5. Return to Excel by press Alt + Q.

Now your worksheet is in VeryHidden mode. You’ll not able to open, view or edit the worksheet unless you set it back from the Visual Basic editor by setting Visible item to original value. FYI, a very hidden worksheet is only invisible, it doesn’t protect your data from being stolen.