software

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(quot;Sheet1quot;).Pictures.Delete

throw this code in a macro, it should delete the pictures--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=519195Good trick! thank you it works ... Greg

quot;davesexcelquot; wrote:

gt;
gt; Worksheets(quot;Sheet1quot;).Pictures.Delete
gt;
gt; throw this code in a macro, it should delete the pictures
gt;
gt;
gt; --
gt; davesexcel
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=519195
gt;
gt;