Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 * |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invisible Range Names
Note well taken!
steve *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting invisible range names - how? | Excel Discussion (Misc queries) | |||
Invisible Column names and Row numbers | Excel Worksheet Functions | |||
converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES | Excel Discussion (Misc queries) | |||
Invisible Defined Names | Excel Discussion (Misc queries) |