Macro command button gets Deleted

[paultrins]

I am new to this forum.
I have an excel file with macros.I group all the shapes on a sheet.The command button and check boxes also gets included in it.When I delete the shape group the command button gets deleted.I just want to delete the shape group without the button and check boxes
Any suggestions?
Excel 97-2003

Paul

 

[Tom Urtis]

Did you create the controls from the Forms toolbar or the activex control toolbox.

And, what controls did you create? Command buttons, checkboxes, and what else.

 

[paultrins]

Thank you Tom for the reply
I created command buttons and check boxes from the forms tool box
The code works well in excel 2007.I saved the workbook as Excel 97-2003.When I open the file in another computer which has Excel 2003 it deletes the command button.


'' The following code selects the shapes and group them
myDocument.Select
myDocument.Shapes.SelectAll
Selection.Group.Name = "TriGroup1"

'' The following code deletes the group

myDocument.Shapes("TriGroup1").Delete

''The problem is when it deletes the shape it deletes the command buton and check box

'' Any suggestions ?