Deleting Name from Name Box
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
"Workbook" wrote in message
...
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?
|