How to unhide 'Very Hidden' Worksheet
I was messing around in the sheet settings and somehow managed to make a sheet 'very hidden', but I cannot seem to make it visible again. How can I make it visible?
I am using Excel 2010.
One option is to do it with VBA
Try out the below:
Sub UnHide()
Dim ws As Worksheet
For Each ws In Sheets
ws.Visible = True
Next
End Sub
This will show up ALL sheets that are hidden, or very hidden
You do it like this:
- Open VBA editor (Alt+F11)
- Open the VBAProject corresponding to your file.
- Open the "Microsoft Excel-objects" folder
- Select the Sheet you've hidden.
- Go to the properties (press F4)
- Change the property "Visible" to xlSheetVisible instead of xlSheetVeryHidden