NamedRange.ClearOutline Method

Clears the outline for the NamedRange control.

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

Syntax

'Declaration
Function ClearOutline As Object

Object ClearOutline()

Return Value

Type: System.Object

Examples

The following code example uses the AutoOutline method to create an outline for a NamedRange control, and then prompts you to clear the outline by calling the ClearOutline method.

This example is for a document-level customization.

    Private Sub SetOutline()
        Dim namedRange1 As Microsoft.Office.Tools.Excel.NamedRange _
            = Me.Controls.AddNamedRange(Me.Range("A1", "C5"), _
            "namedRange1")

        namedRange1.AutoOutline()

        If MessageBox.Show("Clear the outline?", "Test", _
            MessageBoxButtons.YesNo) = DialogResult.Yes Then
            namedRange1.ClearOutline()
        End If
    End Sub

private void SetOutline()
{
    Microsoft.Office.Tools.Excel.NamedRange namedRange1 =
        this.Controls.AddNamedRange(this.Range["A1", "C5"],
        "namedRange1");

    namedRange1.AutoOutline();

    if (MessageBox.Show("Clear the outline?", "Test",
        MessageBoxButtons.YesNo) == DialogResult.Yes)
    {
        namedRange1.ClearOutline();
    }
}

.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