CustomViews Collection Object
CustomViews (CustomView)
A collection of custom workbook views. Each view is represented by a CustomView object.
Using the CustomViews Collection
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