NamedRange.Style Property

Gets or sets a Style that represents the style of the NamedRange control.

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

Syntax

'Declaration
Property Style As Object

Object Style { get; set; }

Property Value

Type: System.Object
A Style that represents the style of the NamedRange control.

Examples

The following code example creates a new custom style that displays text vertically and then sets a NamedRange to use this style.

This example is for a document-level customization.

Private Sub CreateStyle()
        Dim verticalStyle As Excel.Style = _
            Globals.ThisWorkbook.Styles.Add("Vertical Text")
        verticalStyle.Orientation = Excel.XlOrientation.xlVertical

        Dim namedRange1 As Microsoft.Office.Tools.Excel.NamedRange _
            = Me.Controls.AddNamedRange(Me.Range("A1"), _
            "namedRange1")
        namedRange1.Style = verticalStyle
        namedRange1.Value2 = "This text is vertical" 
    End Sub

private void CreateStyle()
{
    Excel.Style verticalStyle = Globals.ThisWorkbook.Styles.Add(
        "Vertical Text");
    verticalStyle.Orientation = Excel.XlOrientation.xlVertical;

    Microsoft.Office.Tools.Excel.NamedRange namedRange1 =
        this.Controls.AddNamedRange(this.Range["A1"],
        "namedRange1");
    namedRange1.Style = verticalStyle;
    namedRange1.Value2 = "This text is vertical";
}

.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

NamedRange Interface

Microsoft.Office.Tools.Excel Namespace