View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joerg Mochikun Joerg Mochikun is offline
external usenet poster
 
Posts: 104
Default 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?