How to make hidden sheet invisible

  • Thread starter Thread starter LLee2
  • Start date Start date
Isn't a hidden sheet already not visible?

You could go into the VBE and change its .visible property to xlsheetveryhidden.

Did you mean that?

This would make it so that the sheet name didn't show up under
Format|Sheet|Unhide

That's about the only difference.
 
Does anyone know how to make a hidden sheet invisible?

Thanks,
llee2
Click to expand...
I think you need VBA...

Make a new workbook with 2 or more sheets...
Key Alt-F11
Insert a Module
Copy the following code there... and hit F5

Sub HideOne()
'run this on a new workbook with 2 sheets
this1 = Sheets(1).Name
Sheets(1).Tab.ColorIndex = 3
Sheets(2).Activate

resp = MsgBox("Hide First Sheet?", vbOKOnly)
Sheets(this1).Visible = xlSheetHidden

resp = MsgBox("Hide it TOTALLY?" & Chr(10) & "Not visible under Format-
Sheet->Unhide", vbYesNo)
Click to expand...
If resp = vbYes Then
Sheets(this1).Visible = xlSheetVeryHidden
End If

resp = MsgBox("Bring it back?", vbYesNo)
If resp = vbYes Then
Sheets(this1).Visible = xlSheetVisible
End If

End Sub
 
It could also be done w/o VBA. Click View/Toolbars/Control Toolbox. Click
the properties button and change the visible property there.

Of course, if changed to very hidden - I believe the OP will need to use VBA
to unhide the sheet.
 
Or go through the VBE and change the properties in the property window (with
that worksheet object selected in the project explorer window).
 
It was.

I was trying to emphasize that you don't actually need VBA to unhide a very
hidden sheet. (I don't count going to the VBE as using code.)
 
Sorry - of course if it can be hidden w/the VBE it can be unhidden. Looks
like I picked a bad week to stop sniffing glue.
 
<g> I didn't know that was from 1980. I thought it more mid to late 80's.
Time flies when your memory sucks.
 
Back
Top