Share via


Worksheet.Visible Property

Excel Developer Reference

Returns or sets an XlSheetVisibility value that determines whether the object is visible.

Syntax

expression.Visible

expression   A variable that represents a Worksheet object.

Example

This example hides Sheet1.

Visual Basic for Applications
  Worksheets("Sheet1").Visible = False

This example makes Sheet1 visible.

Visual Basic for Applications
  Worksheets("Sheet1").Visible = True

This example makes every sheet in the active workbook visible.

Visual Basic for Applications
  For Each sh In Sheets
 sh.Visible = True
Next sh

This example creates a new worksheet and then sets its Visible property to xlVeryHidden. To refer to the sheet, use its object variable, newSheet, as shown in the last line of the example. To use the newSheet object variable in another procedure, you must declare it as a public variable (Public newSheet As Object) in the first line of the module preceding any Sub or Function procedure.

Visual Basic for Applications
  Set newSheet = Worksheets.Add
newSheet.Visible = xlVeryHidden
newSheet.Range("A1:D4").Formula = "=RAND()"

See Also