Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting a row | Excel Discussion (Misc queries) | |||
Deleting every other row? | Excel Discussion (Misc queries) | |||
Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel |