Can't remove Radio Button

[Guest]

I have a sheet which used "Yes/No" Radio Buttons which I've now replaced with
Tick Boxes. There is one button which I cannot remove. I can't select it,
can't make it active, therefor can't remove it.

Please help!

 

[Tom Ogilvy]

Activesheet.Optionbuttons.Delete
for each ole in Activesheet.OleObjects
if typeof ole.Object is msforms.Optionbutton then
ole.delete
end if
Next

 

[Earl Kiosterud]

Ken,

It may be from the Control Toolbox, instead of the Forms Toolbar, in which
case you can't select it. Get the Control Toolbox (View - Toolbars). Put
it in Design Mode with the button. Now you should be able to select it and
delete it.