Worksheet.Visible property (Excel)
Returns or sets an XlSheetVisibility value that determines whether the object is visible.
expression A variable that represents a Worksheet object.
This example hides Sheet1.
Worksheets("Sheet1").Visible = False
This example makes Sheet1 visible.
Worksheets("Sheet1").Visible = True
This example makes every sheet in the active workbook visible.
For Each sh In Sheets sh.Visible = True Next sh
This example creates a new worksheet and then sets its Visible property to xlSheetVeryHidden. 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.
Set newSheet = Worksheets.Add newSheet.Visible = xlSheetVeryHidden newSheet.Range("A1:D4").Formula = "=RAND()"
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.