How to create super hidden secrete worksheets

Many of the times there are situations where you wanted to have one confidential worksheet where you can keep your secrete data and which you refer on other sheets, or may be only some hidden worksheet whereby only specific person knows about it. And you wonder how to do that in Excel.

Yes there is a way in Excel, no I am not talking about sheet ->hide, all knows about it. It hides sheets from appearing in the tabs but when user goes and select Unhide Sheets from format menu it shows the list of all hidden sheets so a big problem!!!!. There is one better way to achieve more than just hide. And that’s the visibility of the sheet. Now in Excel there are 3 modes associated with sheet’s visible property as follows:

1. xlSheetVisible (-1)

2. xlSheetHidden (0)

3. xlSheetVeryHidden(2)

You can see and change this using VBA Editor (Alt + F11), Select sheet in Project Explorer (Ctrl + R), and see last property in properties window (F4).

So when you select ‘Sheet Hide’ the visible property to ‘0’ i.e. ‘xlSheetHidden’, which also appears in the list of hidden sheets.

To make sheets that will not appear in hidden sheets list, we need to change this property to xlSheetVeryHidden(2), so once you through with your work on that sheet you can come in VBA Editor and create this way super hidden secrete worksheet.

But wait that’s not all you can even use references from this sheet on other hidden sheets, as the sheet is still present in workbook all calculations will properly work.

But yes you still have to protect your workbook for the purpose of security.