CustomViews Collection Object

Microsoft Excel Visual Basic

WorkbookCustomViews
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