CustomView Object
Represents a custom workbook view. The CustomView object is a member of the CustomViews collection.
Using the CustomView Object
Use CustomViews(index), where index is the name or index number of the custom view, to return a CustomView object. The following example shows the custom view named "Current Inventory."
ThisWorkbook.CustomViews("Current Inventory").Show