WorkbookBase.Windows Property

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

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 Windows collection that represents all the windows in the workbook.

public:
 property Microsoft::Office::Interop::Excel::Windows ^ Windows { Microsoft::Office::Interop::Excel::Windows ^ get(); };

public Microsoft.Office.Interop.Excel.Windows Windows { get; }

member this.Windows : Microsoft.Office.Interop.Excel.Windows

Public ReadOnly Property Windows As Windows

Property Value

Windows

A Windows collection that represents all the windows in the workbook.

Examples

The following code example uses the Windows property to display formulas, gridlines, and the outline of the current workbook.

This example is for a document-level customization.

private void SetWindowOptions()
{
    this.Windows[1].DisplayFormulas = true;
    this.Windows[1].DisplayGridlines = true;
    this.Windows[1].DisplayOutline = true;
}

Private Sub SetWindowOptions()
    Me.Windows(1).DisplayFormulas = True
    Me.Windows(1).DisplayGridlines = True
    Me.Windows(1).DisplayOutline = True
End Sub

Remarks

This property returns a collection of both visible and hidden windows.

Applies to

Partager via