Add Method (CustomViews Object)
Applies To
CustomViews collection object.
Description
Creates a new custom view. Returns a CustomView object that represents the new view.
Syntax
expression.Add(ViewName, PrintSettings, RowColSettings)
expression Required. An expression that returns a CustomViews object.
ViewName Required String. The name of the new view.
PrintSettings Optional Variant. True to include print settings in the custom view.
RowColSettings Optional Variant. True to include settings for hidden rows and columns (including filter information) in the custom view.
See Also
PrintSettings property, RowColSettings property.
Example
This example creates a new custom view named "Summary" in the active workbook.
ActiveWorkbook.CustomViews.Add "Summary", True, True