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.