Custom View Object and the Custom Views Collection

The CustomViews collection holds the list of custom views associated with a workbook. Each CustomView object holds the attributes associated with a workbook custom view. A custom view holds settings such as window size, window position, column widths, hidden columns, and print settings of a workbook. The parent object of the CustomViews collection is the Workbook object.

The CustomViews collection has one other property besides the typical collection attributes. The Add method adds a custom view to the CustomViews collection. The Add method accepts a name for the view with the ViewName parameter. Optionally, the Add method accepts whether print settings are included (PrintSettings) and whether hidden rows and columns are included (RowColSettings).

0 0

Post a comment