Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Determines whether the object is visible.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
<BrowsableAttribute(False)> _
Public Property Visible As XlSheetVisibility
'Usage
Dim instance As ChartSheet
Dim value As XlSheetVisibility
value = instance.Visible
instance.Visible = value
[BrowsableAttribute(false)]
public XlSheetVisibility Visible { get; set; }
[BrowsableAttribute(false)]
public:
property XlSheetVisibility Visible {
XlSheetVisibility get ();
void set (XlSheetVisibility value);
}
public function get Visible () : XlSheetVisibility
public function set Visible (value : XlSheetVisibility)
Property Value
Type: XlSheetVisibility
Examples
The following code example uses the Visible property to hide the current Microsoft.Office.Tools.Excel.ChartSheet.
Private Sub HideChartSheet()
Globals.Sheet1.Range("A1", "A5").Value2 = 22
Globals.Sheet1.Range("B1", "B5").Value2 = 55
Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
Excel.XlRowCol.xlColumns)
Me.ChartType = Excel.XlChartType.xl3DBarClustered
Me.Visible = Excel.XlSheetVisibility.xlSheetHidden
End Sub
private void HideChartSheet()
{
Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
Globals.Sheet1.Range["B1", "B5"].Value2 = 55;
this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
Excel.XlRowCol.xlColumns);
this.ChartType = Excel.XlChartType.xl3DBarClustered;
this.Visible = Excel.XlSheetVisibility.xlSheetHidden;
}
.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.