View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Copp[_3_] David Copp[_3_] is offline
external usenet poster
 
Posts: 3
Default Using Worksheet Codename to Determine Worksheet Existence

Greetings,

I've got a worksheet codename (activeworkbook.activesheet.codename) and wish
to use it to determine if the worksheet exists at a later point in time.
Presuming I've stored the codename, looking for a way to see if worksheet
exists (i.e. open) without knowing it's "friendly" name or worksheet index.
Any ideas?

Is it possible to get "friendly" name from codename? (then check friendly
name)
Other methods welcome.

Thanks,

Dave