Get the name of a group given the reference to a shape within the group
'ParentGroup' was only made available in XL2002.
Too bad. I didn't know that but then I hadn't heard of the ParentGroup
object until I worked on your post<g. Looks like MS plugged a hole with
ParentGroup because I don't see how to get from a control to its group
object without it. Other that maintaining a table of objects and the group
objects they belong to that is.
--
Jim Rech
Excel MVP
|