delete option buttons

  • Thread starter Thread starter iriarte69
  • Start date Start date
I

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?
 
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
 
Back
Top