How to erase pasted controls from an Excel spreadsheet

[capnmike]

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.

 

[Don Guillett]

Try

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

 

[Gord Dibben]

F5>Special>Objects>OK

Hit Delete key.

This will clear ALL objects.


Gord Dibben MS Excel MVP