deletion of option buttons

G

gvm

I know how to create option buttons in a spreadsheet and how to delete them.
My problem is that I need to copy and paste a table of data from a website.
When I select the data from the website, I can't avoid including a column of
option buttons in the table. When I paste the table into a spreadsheet, I
can't find how to delete the option buttons. The option button functions OK
(ie I can activate/deactivate the option) but the normal procedure for
deleting it [ie selecting it by right-clicking and then deleting] doesn't
work. I can't select the box at all.
Any ideas? TIA ... Greg
 
D

davesexcel

Worksheets("Sheet1").Pictures.Delete

throw this code in a macro, it should delete the pictures
 
Top