delete option buttons
 

I copied data friom internet into an excel sheet, and there are option
buttons that I cannot simpply delete, cut nor clear. the option buttons seem
to be above the cells. I see 2, when I clik one a point for selection appears
on this, and when I click on the other the point passes to the other point.
I had this in the past, and there was a way with toolbars to see the
references to these boxes in the sheet, there were more than those which
could be seen, and I had to delete many data not visible relating to these
buttons.
Can you please indicate me how to see where the data refering to these boxes
is?

delete option buttons
 

Try the below

--Activate the sheet which is to be cleared
--Hit the keys (Alt + F11) to launch VBE (Visual Basic Editor)
--Hit (Ctrl + G) so that Immediate window will be enabled
--Paste the below line including ? to the immediate window and enter (Make
sure you press Enter after placing the cursor end of the line)

?Activesheet.drawingObjects.delete

If this post helps click Yes
---------------
Jacob Skaria


" wrote:

I copied data friom internet into an excel sheet, and there are option
buttons that I cannot simpply delete, cut nor clear. the option buttons seem
to be above the cells. I see 2, when I clik one a point for selection appears
on this, and when I click on the other the point passes to the other point.
I had this in the past, and there was a way with toolbars to see the
references to these boxes in the sheet, there were more than those which
could be seen, and I had to delete many data not visible relating to these
buttons.
Can you please indicate me how to see where the data refering to these boxes
is?

delete option buttons
 

Press F5 and select Special and select Objects.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



" wrote:

I copied data friom internet into an excel sheet, and there are option
buttons that I cannot simpply delete, cut nor clear. the option buttons seem
to be above the cells. I see 2, when I clik one a point for selection appears
on this, and when I click on the other the point passes to the other point.
I had this in the past, and there was a way with toolbars to see the
references to these boxes in the sheet, there were more than those which
could be seen, and I had to delete many data not visible relating to these
buttons.
Can you please indicate me how to see where the data refering to these boxes
is?