Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear all including objects without deleting sheets
I thank all of you for the help. The replies were great!
"Gord Dibben" wrote: Sub clear_objects() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets If ws.Tab.ColorIndex = xlNone Then With ws .DrawingObjects.Delete .Cells.Clear End With End If Next ws End Sub Gord Dibben MS Excel MVP On Thu, 15 Apr 2010 10:29:02 -0700, Curt wrote: I would like a macro that uses the "EDIT" - "CLEAR ALL" command for all sheets that do not have colored tabs. I would also like it to remove all charts, objects, images, etc. for all sheets that do not have colored tabs. Currently, I can only remove all objects by manually deleting each object one at a time. Deleting the sheets is not an option because that results in cell refrences for me as I refrence cells in the sheets that I am trying to clear. Any help is greatly appreciated! Curt J . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clear all including objects without deleting sheets | Excel Programming | |||
Clear all including objects without deleting sheets | Excel Programming | |||
Copy Excel Chart (including drawn objects) into Word | Charts and Charting in Excel | |||
Including objects based on a condition | Excel Worksheet Functions | |||
Including control toolbox objects in tab order | Excel Programming |