Thread: Name Box
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
PraxisPete
 
Posts: n/a
Default Name Box

Thank you for your replies, problem solved.

"Jim Rech" wrote:

You have to do it by code:

Names("ABC").Visible = False

or with a utility:

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

--
Jim
"PraxisPete" wrote in message
...
| 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