Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,344
Default 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?

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 104
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting a row carrera Excel Discussion (Misc queries) 2 April 10th 08 07:45 PM
Deleting every other row? The Joe Excel Discussion (Misc queries) 3 February 6th 07 08:05 PM
Deleting cell data without deleting formula Tom Hall Excel Discussion (Misc queries) 4 October 29th 06 04:07 PM
deleting values in a worksheet without deleting the formulas patti Excel Worksheet Functions 1 October 28th 05 09:49 PM
how prevent formula in cell from deleting when deleting value???? sh-boom New Users to Excel 1 September 30th 05 06:12 PM


All times are GMT +1. The time now is 02:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"