[RESOLVED] Selecting shapes in a group

[Fonty]

I have just realized that you can select a sing shape wh9ich is part of a group in Excel 2007. However, it is impossible to do so in 2003.
Am I forced to include an ungroup and regroup procedure?

[Siddharth Rout]

yes you will have to ungroup them

here is a single excercise

1)

create 4 shapes in an excel sheet and then run this code

Sub test()
Dim shp As Shape
For Each shp In ActiveSheet.Shapes
    MsgBox shp.Name
Next shp
End Sub

2) Group the shapes and then run the code again. It won't give you different names but something like "Group1"