Name Box

[Guest]

Hi Everybody

How do you create Hidden Names for ranges? I would like to name a range of
cells and not have the name appear in the drop down Name box, but be able to
refer to it in VBA code.

I am using Excel 2002

Many thanks

 

[Norman Jones]

Hi PraxisPete,

Try something like:

'=============>>
Public Sub Tester03()
With ActiveWorkbook
.Names.Add "Test", _
RefersTo:=.Sheets("Sheet1").Range("A1"), _
Visible:=False
End With
End Sub
'<<=============

 

[Jim Rech]

You have to do it by code:

Names("ABC").Visible = False

or with a utility:

http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.htm

--
Jim
| Hi Everybody
|
| How do you create Hidden Names for ranges? I would like to name a range
of
| cells and not have the name appear in the drop down Name box, but be able
to
| refer to it in VBA code.
|
| I am using Excel 2002
|
| Many thanks

 

[Guest]

Thank you for your replies, problem solved.