Class ChartView (Excel VBA)
The class ChartView represents a view of a chart.
Set
To use a ChartView class variable it first needs to be instantiated, for example
Dim lngIndex As Long: lngIndex =
Dim wnd As Window: Set wnd =
Dim chrvwSheetView As ChartView
Set chrvwSheetView = wnd.SheetViews(Index:=lngIndex)
The following procedures can be used to set variables of type ChartView: SheetViews.Item, SheetViews.Item and Window.SheetViews
For Each
Here is an example of processing the ChartView items in a collection.
Dim wnd As Window: Set wnd =
Dim chrvwSheetView As ChartView
For Each chrvwSheetView In wnd.SheetViews
Next chrvwSheetView
Parent
Returns the parent object for the specified object. Read-only.
Sheet
Returns the sheet name for the specified ChartView object.
SheetViews.Count
Returns the number of objects in the collection.
SheetViews.Item
Returns a SheetView object that represents views in a workbook.
Syntax : expression.Item (Index)
Index: Index value of the view.
SheetViews.Parent
Returns the parent object for the specified object. Read-only.