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.

0

4 Answers

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

8

You do it like this:

1. Open VBA editor (Alt+F11)
2. Open the VBAProject corresponding to your file.
3. Open the "Microsoft Excel-objects" folder
4. Select the Sheet you've hidden.
5. Go to the properties (press F4)
6. Change the property "Visible" to xlSheetVisible instead of xlSheetVeryHidden

0

In VBA editor, go to the sheet properties and change the below property

5

To keep them hidden, but visible in the options menu (UnHide..), use the same code but with this..

Sub StillHide()
Dim ws As Worksheet
For Each ws In Sheets ws.Visible = xlSheetHidden <-- change from Visible to this.
Next
End Sub

That way the tabs are not all of a suddenly showing to the user. They are still "hidden".

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy