NamedRange.PageBreak Property (2007 System)
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.