Worksheet.VPageBreaks Property (2007 System)

Gets a VPageBreaks collection that represents the vertical page breaks on the sheet.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)

Syntax

'Declaration
<BrowsableAttribute(False)> _
Public ReadOnly Property VPageBreaks As VPageBreaks

'Usage
Dim instance As Worksheet 
Dim value As VPageBreaks 

value = instance.VPageBreaks

[BrowsableAttribute(false)]
public VPageBreaks VPageBreaks { get; }

[BrowsableAttribute(false)]
public:
property VPageBreaks^ VPageBreaks {
    VPageBreaks^ get ();
}

public function get VPageBreaks () : VPageBreaks

Property Value

Type: VPageBreaks
A VPageBreaks collection that represents the vertical page breaks on the sheet.

Examples

The following code example uses the VPageBreaks property to add a vertical page break at cell C5.

This example is for a document-level customization.

Private Sub InsertPageBreaks()
    Dim hbreak As Excel.HPageBreak = _
        Me.HPageBreaks.Add(Me.Range("C5"))
    Dim vbreak As Excel.VPageBreak = _
        Me.VPageBreaks.Add(Me.Range("C5"))
End Sub

private void InsertPageBreaks()
{
    Excel.HPageBreak hbreak =
        this.HPageBreaks.Add(this.Range["C5", missing]);
    Excel.VPageBreak vbreak =
        this.VPageBreaks.Add(this.Range["C5", missing]);
}

.NET Framework Security

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

Worksheet Class

Worksheet Members

Microsoft.Office.Tools.Excel Namespace