Invisible Range Names
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... |
Invisible Range Names
"Chris Gorham" wrote in message
... 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 * |
Invisible Range Names
Chris,
Try: ActiveWorkbook.Names.Add Name:="myname", RefersTo:="=sheet1!A1:A5", Visible:=False (watch for word wrap) steve "Chris Gorham" wrote in message ... 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... |
Invisible Range Names
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" wrote: Chris, Try: ActiveWorkbook.Names.Add Name:="myname", RefersTo:="=sheet1!A1:A5", Visible:=False (watch for word wrap) steve "Chris Gorham" wrote in message ... 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... |
Invisible Range Names
Note well taken!
steve *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
All times are GMT +1. The time now is 08:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com