Hello
Can someone help me here.
I am able to group certain checkboxes using the following code. I got it through the record macro function in excel 2007
Sub Macro1()
ActiveSheet.Shapes.Range(Array("Check Box 2", "Check Box 3", "Check Box 4", "Check Box 5")).Select
Selection.ShapeRange.Group.Select
End Sub
In the same manner the code (got it through the record macro function) for ungrouping is
[Sub Macro2()
ActiveSheet.Shapes("Group 14").Select
Selection.ShapeRange.Ungroup.Select
End Sub]
But each time the grouping happens the group of checkboxes get a new number and the ungrouping macro cannot be used.
I would appreciate any help that I can get here.
Thanks in advance
Regards
Sreeraj
Bookmarks