Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets an Microsoft.Office.Interop.Excel.HPageBreaks collection that represents the horizontal page breaks on the sheet.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Public ReadOnly Property HPageBreaks As HPageBreaks
Get
public HPageBreaks HPageBreaks { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.HPageBreaks
An Microsoft.Office.Interop.Excel.HPageBreaks collection that represents the horizontal page breaks on the sheet.
Remarks
There is a limit of 1026 horizontal page breaks per sheet.
Examples
The following code example uses the HPageBreaks property to add a horizontal 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.