How do I remove a non-toolbar custom button from a sheet?

I created a custom button that I assigned to a macro and placed it into a
worksheet. Now I want to delete that button, but I cannot find anyway to
delete it. Does anyone know how to select the button and delete it?

Sub DeleteAllShapes()
for each shp in ActiveSheet.Shapes
shp.Delete
Next
End sub

--
Regards,
Tom Ogilvy

"AaronInCarolina" <[email protected]> wrote in
message news:[email protected]...
> I created a custom button that I assigned to a macro and placed it into a
> worksheet. Now I want to delete that button, but I cannot find anyway to
> delete it. Does anyone know how to select the button and delete it?

remove any autofilter you might have in effect before running the macro.

--
Regards,
Tom Ogilvy


"AaronInCarolina" <[email protected]> wrote in
message news:[email protected]...
> I created a custom button that I assigned to a macro and placed it into a
> worksheet. Now I want to delete that button, but I cannot find anyway to
> delete it. Does anyone know how to select the button and delete it?

Hi

Also Data>Validation arrows

Sub Shapes3()
'Loop through the Shapes collection and use the Type number of the control
'Example only for the Forms controls
Dim myshape As Shape
For Each myshape In ActiveSheet.Shapes
If myshape.Type = 8 And myshape.FormControlType <> 2 Then myshape.Delete
Next myshape
ActiveSheet.DropDowns.Delete
End Sub

I have more info here about that
http://www.rondebruin.nl/controlsobjectsworksheet.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Tom Ogilvy" <[email protected]> wrote in message news:[email protected]...
> remove any autofilter you might have in effect before running the macro.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "AaronInCarolina" <[email protected]> wrote in
> message news:[email protected]...
>> I created a custom button that I assigned to a macro and placed it into a
>> worksheet. Now I want to delete that button, but I cannot find anyway to
>> delete it. Does anyone know how to select the button and delete it?
>
>