WorksheetBase.Names Property

Gets a Microsoft.Office.Interop.Excel.Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix).

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

Syntax

'Declaration
Public ReadOnly Property Names As Names
    Get

public Names Names { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.Names
A Microsoft.Office.Interop.Excel.Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix).

Examples

The following code example uses the Names property to add a name to the worksheet. The example then displays the Define Name dialog to verify that the name was added.

This example is for a document-level customization.

Private Sub AddName()
    Dim name1 As Excel.Name = _
        Me.Names.Add("Microsoft", Me.Range("A1"), _
            True, ShortcutKey:="Ctrl-R")

    ' Show Define Name dialog to verify that the Name was added.
    Me.Application.Dialogs(Excel.XlBuiltInDialog.xlDialogDefineName).Show()
End Sub

private void AddName()
{
    Excel.Name name1 = this.Names.Add("Microsoft",
        this.Range["A1", missing], true, missing, "Ctrl-R",
        missing, missing, missing, missing, missing, missing);

    // Show Define Name dialog to verify that the Name was added.
    this.Application.Dialogs[Excel.XlBuiltInDialog.xlDialogDefineName].Show(
        missing, missing, missing, missing, missing, missing, missing, missing,
        missing, missing, missing, missing, missing, missing, missing, missing,
        missing, missing, missing, missing, missing, missing, missing, missing,
        missing, missing, missing, missing, missing, missing);
}

.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

WorksheetBase Class

Microsoft.Office.Tools.Excel Namespace