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