WorkbookBase.CustomViews Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets a CustomViews collection that represents all the custom views for the workbook.
public Microsoft.Office.Interop.Excel.CustomViews CustomViews { get; }
Property Value
A CustomViews collection that represents all the custom views for the workbook.
Examples
The following code example uses the CustomViews property to add a custom view named "Summary" to the current workbook, and then programmatically displays the Custom Views dialog to demonstrate that the new custom view was created.
This example is for a document-level customization.
private void AddCustomView()
{
this.CustomViews.Add("Summary", true, true);
this.Application.Dialogs[Excel.XlBuiltInDialog.xlDialogCustomViews].Show();
}
Private Sub AddCustomView()
Me.CustomViews.Add("Summary", True, True)
Me.Application.Dialogs( _
Excel.XlBuiltInDialog.xlDialogCustomViews).Show()
End Sub