Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Development Tools and Languages
Visual Studio 2008
Visual Studio
Visual Studio Tools for Office
Reference
2007 System Managed Reference
Microsoft.Office.Tools.Excel Namespace (2007 System)
ChartSheet Class (2007 System)
ChartSheet Properties (2007 System)
_CodeName Property (2007 System)
Application Property (2007 System)
Area3DGroup Property (2007 System)
AutoScaling Property (2007 System)
BackWall Property (2007 System)
Bar3DGroup Property (2007 System)
BarShape Property (2007 System)
ChartArea Property (2007 System)
ChartStyle Property (2007 System)
ChartTitle Property (2007 System)
ChartType Property (2007 System)
CodeName Property (2007 System)
Column3DGroup Property (2007 System)
Corners Property (2007 System)
Creator Property (2007 System)
DataTable Property (2007 System)
DepthPercent Property (2007 System)
DisplayBlanksAs Property (2007 System)
Elevation Property (2007 System)
Floor Property (2007 System)
GapDepth Property (2007 System)
HasAxis Property (2007 System)
HasDataTable Property (2007 System)
HasLegend Property (2007 System)
HasPivotFields Property (2007 System)
HasTitle Property (2007 System)
HeightPercent Property (2007 System)
Hyperlinks Property (2007 System)
Index Property (2007 System)
InnerObject Property (2007 System)
Legend Property (2007 System)
Line3DGroup Property (2007 System)
MailEnvelope Property (2007 System)
Name Property (2007 System)
Next Property (2007 System)
OnDoubleClick Property (2007 System)
OnSheetActivate Property (2007 System)
OnSheetDeactivate Property (2007 System)
PageSetup Property (2007 System)
Parent Property (2007 System)
Perspective Property (2007 System)
Pie3DGroup Property (2007 System)
PivotLayout Property (2007 System)
PlotArea Property (2007 System)
PlotBy Property (2007 System)
PlotVisibleOnly Property (2007 System)
Previous Property (2007 System)
ProtectContents Property (2007 System)
ProtectData Property (2007 System)
ProtectDrawingObjects Property (2007 System)
ProtectFormatting Property (2007 System)
ProtectGoalSeek Property (2007 System)
ProtectionMode Property (2007 System)
ProtectSelection Property (2007 System)
RightAngleAxes Property (2007 System)
Rotation Property (2007 System)
Scripts Property (2007 System)
Shapes Property (2007 System)
ShowDataLabelsOverMaximum Property (2007 System)
SideWall Property (2007 System)
SubType Property (2007 System)
SurfaceGroup Property (2007 System)
Tab Property (2007 System)
Type Property (2007 System)
Visible Property (2007 System)
Walls Property (2007 System)
WallsAndGridlines2D Property (2007 System)
Expand Minimize
This topic has not yet been rated - Rate this topic

ChartSheet.Visible Property (2007 System)

Visual Studio 2008

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)
C#
C++
JScript
VB
Copy 
[BrowsableAttribute(false)]
public XlSheetVisibility Visible { get; set; }

Property Value

Type: XlSheetVisibility

The following code example uses the Visible property to hide the current Microsoft.Office.Tools.Excel.ChartSheet.

C#
VB
Copy 
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;
}
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.