sheethidden & sheetveryhidden

[jlr_nz]

I am having some problems with unhiding a "sheetveryhidden" workshee
and then hiding it again "sheetveryhidden". I can only hide it agai
"sheethidden"

Using VBA is there a way to hide a "sheetvisible" t
"sheetveryhidden"?

Thanks

 

[Don Guillett]

Here is one I use to toggle

Sub hideunhide()
If Sheets("kits").Visible = xlVeryHidden Then
Sheets("kits").Visible = True
Sheets("kits").Unprotect
Sheets("parts").Visible = True
Else
Sheets("parts").Visible = xlVeryHidden
Sheets("kits").Protect
Sheets("kits").Visible = xlVeryHidden
End If
ThisWorkbook.Save
End Sub

 

[Guest]

Try

Activesheet.Visible = xlSheetVeryHidden