Class ChartView (Excel VBA)
The class ChartView represents a view of a chart. To use a ChartView class variable it first needs to be instantiated, for example
Dim chrvw as ChartView
Set chrvw = ActiveWindow.SheetViews(Index:=1)
For Each
Here is an example of processing the ChartView items in a collection.
Dim chrvwSheetView As ChartView
For Each chrvwSheetView In ActiveWindow.SheetViews
Next chrvwSheetView
Sheet
Returns the sheet name for the specified ChartView object.
Dim strSheet As String
strSheet = ActiveWindow.SheetViews(1).Sheet