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 or sets the ___location of a page break.
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 Property PageBreak As Integer
'Usage
Dim instance As NamedRange
Dim value As Integer
value = instance.PageBreak
instance.PageBreak = value
[BrowsableAttribute(false)]
public int PageBreak { get; set; }
[BrowsableAttribute(false)]
public:
property int PageBreak {
int get ();
void set (int value);
}
public function get PageBreak () : int
public function set PageBreak (value : int)
Property Value
Type: System.Int32
The ___location of a page break.
Remarks
You can set this property using one of the following XlPageBreakvalues:
This property can return the ___location of either automatic or manual page breaks, but it can only set the ___location of manual breaks (it can only be set to xlPageBreakManual or xlPageBreakNone).
Examples
The following code example creates a NamedRange and then uses the PageBreak property to set a page break at the NamedRange.
This example is for a document-level customization.
Private pageBreakRange As Microsoft.Office.Tools.Excel.NamedRange
Private Sub SetPageBreak()
pageBreakRange = Me.Controls.AddNamedRange( _
Me.Range("C4"), "pageBreakRange")
Me.pageBreakRange.PageBreak = _
Fix(Excel.XlPageBreak.xlPageBreakManual)
End Sub
Microsoft.Office.Tools.Excel.NamedRange pageBreakRange;
private void SetPageBreak()
{
pageBreakRange = this.Controls.AddNamedRange(
this.Range["C4", missing], "pageBreakRange");
this.pageBreakRange.PageBreak =
(int)Excel.XlPageBreak.xlPageBreakManual;
}
.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.