Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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! |
#2
![]() |
|||
|
|||
![]()
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." wrote in message ... 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! |
#3
![]() |
|||
|
|||
![]()
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." wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
Can you create a check box or radio button in Excel? | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
command button moves | Excel Discussion (Misc queries) | |||
How do I setup a spin button in excel | Excel Discussion (Misc queries) |