deletion of option buttons
 

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

deletion of option buttons
 

Worksheets("Sheet1").Pictures.Delete

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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519195

deletion of option buttons
 

Good trick! thank you it works ... Greg

"davesexcel" wrote:


Worksheets("Sheet1").Pictures.Delete

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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519195