Deleting Name from Name Box
 

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

--
Thanks,
Shane Devenshire


"Workbook" wrote:

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?

Deleting Name from Name Box
 

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


"ShaneDevenshire" wrote in
message ...
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

--
Thanks,
Shane Devenshire


"Workbook" wrote:

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?