Unhide worksheet?

crapit · Dec 2, 2003

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

Harald Staff · Dec 2, 2003

Hi

Macro code:

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

Arvi Laanemets · Dec 2, 2003

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.

Unhide worksheet?

crapit

Harald Staff

Arvi Laanemets