CustomViews Object (Excel)
A collection of custom workbook views.
Each view is represented by a CustomView object.
Use the CustomViews property to return the CustomViews collection. Use the Add method to create a new custom view and add it to the CustomViews collection. The following example creates a new custom view named "Summary."
ActiveWorkbook.CustomViews.Add "Summary", True, True