Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Controls on Spreadsheet | Excel Worksheet Functions | |||
ERASE THE "NUMBER 1" IN THE MIDDLE OF SPREADSHEET | Excel Discussion (Misc queries) | |||
find formula used when spreadsheet has been cut / pasted? | Excel Discussion (Misc queries) | |||
HTML controls in spreadsheet | New Users to Excel | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) |