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.


"daregreatly" wrote:

On Apr 6, 12:16 pm, "LLee2" wrote:
Does anyone know how to make a hidden sheet invisible?

Thanks,
llee2
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)
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