NamedRange.Borders Property
Gets a Borders collection that represents the borders of the NamedRange control.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
ReadOnly Property Borders As Borders
Borders Borders { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.Borders
A Borders collection that represents the borders of the NamedRange control.
Examples
The following code example uses the Borders property to draw double lines for the border of a NamedRange, and it uses the Interior property to color the interior of a NamedRange green.
This example is for a document-level customization.
Private bordersRange As Microsoft.Office.Tools.Excel.NamedRange
Private Sub SetBordersAndInterior()
bordersRange = Me.Controls.AddNamedRange( _
Me.Range("B2", "D4"), "namedRange1")
Me.bordersRange.Borders.LineStyle = _
Excel.XlLineStyle.xlDouble
Me.bordersRange.Interior.Color = &HFF00
End Sub
Microsoft.Office.Tools.Excel.NamedRange bordersRange;
private void SetBordersAndInterior()
{
bordersRange = this.Controls.AddNamedRange(
this.Range["B2", "D4"], "namedRange1");
this.bordersRange.Borders.LineStyle =
Excel.XlLineStyle.xlDouble;
this.bordersRange.Interior.Color = 0xFF00;
}
.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.