Invisible Range Names

[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...

 

[Rob Bovey]

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...

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 *

 

[steve]

Chris,

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

(watch for word wrap)

steve

 

[keepitcool]

note that if the activesheet has a a "local" name called sheet1!myname,
this code will update that name, instead of creating a new "global" name.


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[steve bell]

Note well taken!

steve