Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Worksheet.Visible Property

Office 2007
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.

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()"

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.