WorksheetBase.Visible Property
Gets or sets a Microsoft.Office.Interop.Excel.XlSheetVisibility value that determines whether the object is visible.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Public Property Visible As XlSheetVisibility
Get
Set
public XlSheetVisibility Visible { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlSheetVisibility
One of the Microsoft.Office.Interop.Excel.XlSheetVisibility values.
Examples
The following code example uses the Visible property to help select the range of used cells on a worksheet. The example first sets the range of cells from A1 to C3 on the current worksheet to the value 23. If the Visible property indicates that the worksheet is visible, then the example uses the UsedRange property to select the Microsoft.Office.Interop.Excel.Range of used cells.
This example is for a document-level customization.
Private Sub SelectUsedRange()
Me.Activate()
Me.Range("A1", "C3").Value2 = 23
If Me.Visible = Excel.XlSheetVisibility.xlSheetVisible Then
Me.UsedRange.Select()
End If
End Sub
private void SelectUsedRange()
{
this.Activate();
this.Range["A1", "C3"].Value2 = 23;
if (this.Visible == Excel.XlSheetVisibility.xlSheetVisible)
{
this.UsedRange.Select();
}
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.