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?
Printable View
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?
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
vb 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"