Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to delete all msoFreeForms on a chart
Hello Group,
I have a chart sheet that contains a bunch of msoFreeForm objects, and I want to delete all of them hopefully with one statement. If I select one and check its Typename I get "Rectangle". But Activechart.Rectangles.Delete does not delete them. How can I delete them? Thanks, Brian Murphy Austin, Texas |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to delete all msoFreeForms on a chart
Hi Brian,
Brian Murphy wrote: I have a chart sheet that contains a bunch of msoFreeForm objects, and I want to delete all of them hopefully with one statement. If I select one and check its Typename I get "Rectangle". But Activechart.Rectangles.Delete does not delete them. How can I delete them? try this: Dim sh As Shape For Each sh In ActiveSheet.Shapes If sh.Type = msoFreeform Then sh.Delete Next sh or delete all DrawingObjects: ActiveSheet.DrawingObjects.Delete -- Regards Melanie Breden - Microsoft MVP für Excel - http://excel.codebooks.de (Das Excel-VBA Codebook) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to delete all msoFreeForms on a chart
Thank you, Melanie.
I will give that a try. I probably can't do ActiveSheet.DrawingObjects.Delete because of some TextBoxes on the chart. I suppose the loop will work. Too bad there doesn't appear to be a single command to delete all of the same type of Shape. activechart.shapes.SelectAll also selects my textboxes, so no good. Brian "Melanie Breden" wrote in message ... Hi Brian, Brian Murphy wrote: I have a chart sheet that contains a bunch of msoFreeForm objects, and I want to delete all of them hopefully with one statement. If I select one and check its Typename I get "Rectangle". But Activechart.Rectangles.Delete does not delete them. How can I delete them? try this: Dim sh As Shape For Each sh In ActiveSheet.Shapes If sh.Type = msoFreeform Then sh.Delete Next sh or delete all DrawingObjects: ActiveSheet.DrawingObjects.Delete -- Regards Melanie Breden - Microsoft MVP für Excel - http://excel.codebooks.de (Das Excel-VBA Codebook) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete chart | Charts and Charting in Excel | |||
Delete embedded chart, how? | Charts and Charting in Excel | |||
delete chart | Excel Discussion (Misc queries) | |||
Delete Chart | Charts and Charting in Excel | |||
Using VBA to Delete a Chart | Excel Programming |