Thread: Multiple instances of a named range, not in the list
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Multiple instances of a named range, not in the list
No. From XL/VBA Help ("Visible Property"):

True if the object is visible. For a chart or worksheet,
this property can be set to xlVeryHidden. This hides the
object so that the only way for you to make it visible
again is by setting this property to True (the user
cannot make the object visible). Read/write Boolean or Long.





In article .com,
"DaveO" wrote:

And they're all hidden, so not seen in the list. Can these named
ranges be VeryHidden?
Reply With QuoteReply With Quote