Deleting Name from Name Box

  • Thread starter Thread starter Workbook
  • Start date Start date
W

Workbook

Is it possible to delete a name(s) from the name box once you have given a
cell or group of cells a specific name? and if so could you tell me how I can
do so?
 
hi
in 2003, it would be...
insert>name>define
highlight the name, click the delete button. ok

regards
FSt1
 
If you are working with names, then this will make life much easier:

Get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp
 
Go to Insert => Name => Define
Pick the name from the list and in 'Refers to' change the call reference
from e.g.
=Sheet1!$A$1:$A$5
to
=INDIRECT("Sheet1!$A$1:$A$5")

This will prevent the name being shown in the name box.

Cheers,
Joerg Mochikun
 
Hi,

It doesn't look like you got the answer to your question - the answer is No.
The other posts are correct regarding deleting names:
1. In 2003 and earlier you do it via the Insert, Name, Define command -
shortcut key Ctrl+F3
2. In 2007 you do it via Formulas, Name Manager - same shortcut key.
3. If you are using 2003 or earlier an add-in helps quite a bit because the
Define Name dialog box is rather weak. However, 2007 is a big improvement.
4. If you are trying to hide names you can do it with VBA:
ActiveWorkbook.Names.Add Name:="Test", RefersToR1C1:="=Sheet3!R6C7",
Visible:=False
However, it is not visible in the Insert, Name or Go To dialog boxes.

If this helps, please click the Yes button
 
Shane,

the anwer is Yes. I understand that the OP wants to reference cell ranges by
name, but doesn't want the name to appear in the name box.

Joerg
 
Back
Top