Aim: To unhide Very Hidden Sheets in Excel.
As part of a recent data warehouse project, I had to extract data from an Excel spreadsheet (yuck, I know!). Based on some of the formulae in the visible sheets, it was apparent that there was another sheet hidden in the file. However, it was not possible to unhide the sheet via the Home tab on the ribbon, which indicated that it was a Very Hidden Sheet.
Instead, click Alt+F11 to open the “Visual Basic for Applications” Editor. If they are not already visible, open the Project Explorer & Properties Window from the View menu. In the Project Explorer, highlight the hidden sheet. In the Properties Window, you can see that the Visible property is set to “2 – xlSheetVeryHidden”. To unhide the sheet, set the property to “-1 – xlSheetVisible”.
Save & close the Editor. The sheet will now be visible in the spreadsheet.