How to erase pasted controls from an Excel spreadsheet
 

I want to know how to delete/erase several pictures/controls that were
include in data that I copied from a web-page. I can delete the data, but
not the copied-controls.
--
Capnmike

How to erase pasted controls from an Excel spreadsheet
 

Try

for each sh in activesheet.shapes
sh.delete
next sh

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"capnmike" wrote in message
...
I want to know how to delete/erase several pictures/controls that were
include in data that I copied from a web-page. I can delete the data, but
not the copied-controls.
--
Capnmike

How to erase pasted controls from an Excel spreadsheet
 

F5SpecialObjectsOK

Hit Delete key.

This will clear ALL objects.


Gord Dibben MS Excel MVP

On Fri, 18 Jul 2008 14:17:02 -0700, capnmike
wrote:

I want to know how to delete/erase several pictures/controls that were
include in data that I copied from a web-page. I can delete the data, but
not the copied-controls.