Can't remove Radio Button

[Ken G.]

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

--
Regards,
Tom Ogilvy

"Ken G." <[email protected]> wrote in message
news:[email protected]...
> 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!

[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.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Ken G." <[email protected]> wrote in message
news:[email protected]...
>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!