deletion of option buttons

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Worksheets("Sheet1").Pictures.Delete

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top