Invisible Range Names

  • Thread starter Thread starter Chris Gorham
  • Start date Start date
C

Chris Gorham

Hi..I know that it's possible using VBA to set a range
name to invisible (& vice versa) such that it does not
appear in the range name editor available from the
standard drop down. A bit like setting the property of a
sheet to "very hidden". I can't remember the syntax...
 
Chris Gorham said:
Hi..I know that it's possible using VBA to set a range
name to invisible (& vice versa) such that it does not
appear in the range name editor available from the
standard drop down. A bit like setting the property of a
sheet to "very hidden". I can't remember the syntax...
Click to expand...

Hi Chris,

ThisWorkbook.Names("MyName").Visible = False

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
Chris,

Try:
ActiveWorkbook.Names.Add Name:="myname", RefersTo:="=sheet1!A1:A5",
Visible:=False

(watch for word wrap)

steve
 
Back
Top