Can't remove Radio Button

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!

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." <KenG@discussions.microsoft.com> wrote in message
news:97DBE155-9089-40BD-B98F-62E372F9CE12@microsoft.com...
> 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!

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." <KenG@discussions.microsoft.com> wrote in message
news:97DBE155-9089-40BD-B98F-62E372F9CE12@microsoft.com...
>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!