there are two different types of control buttons. One from the
controltoolbox toolbar and one from the Formstoolbar. The method is
slighly different


'control toolbox
Sub test()

For Each obj In Sheets("sheet1").OLEObjects
If TypeName(obj.Object) = "CommandButton" Then
obj.Delete
End If

Next obj

End Sub

'forms
Sub test1()
For Each obj In Sheets("sheet1").Buttons
obj.Delete
Next obj
End Sub


If you have more than one button on the page you may have to look at
the name of the button (what is displayon on the control) to determine
which on eto dlete.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=180227

Microsoft Office Help