CustomViews Collection Object

Microsoft Excel Visual Basic

CustomViews Collection Object

         
Workbooks (Workbook) 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