Share via


NamedRange.AutoOutline Method

Automatically creates an outline for the NamedRange control.

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

Syntax

'Declaration
Function AutoOutline As Object
Object AutoOutline()

Return Value

Type: System.Object

Remarks

If the NamedRange control is a single cell, Microsoft Office Excel creates an outline for the entire sheet. The new outline replaces any existing outline.

Examples

The following code example uses the AutoOutline method to create an outline for a NamedRange control, and then prompts the user 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

See Also

Reference

NamedRange Interface

Microsoft.Office.Tools.Excel Namespace