delete option buttons

[iriarte69]

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?

 

[Jacob Skaria]

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

 

[Ms-Exl-Learner]

Press F5 and select Special and select Objects.

If this post helps, Click Yes!