Unhide worksheet?

[crapit]

Other than fm Format > Sheet > Unhide to reveal hidden worksheets, wat other
methods is used to hide a worksheet?

 

[Harald Staff]

Hi

Macro code:

Sub ShowSummary()
Sheets("Summary").Visible = True
End Sub

 

[Arvi Laanemets]

Hi

You can set the worksheet's Visible property to xlSheetVeryHidden from sheet
properties in VBA Project window or through code. User can't set the very
hidden sheet visible again from Format.Sheet.Unhide otherwise, but only from
VBA Project window or through code again.