Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This will remove chart sheets and embedded charts:
'==================================== Sub ChartsDelete() Dim ch As Chart Dim ws As Worksheet Dim chObj As ChartObject Application.DisplayAlerts = False For Each ch In ActiveWorkbook.Charts ch.Delete Next For Each ws In ActiveWorkbook.Worksheets For Each chObj In ws.ChartObjects chObj.Delete Next Next Application.DisplayAlerts = True End Sub '================================== bambam77 wrote: Is it possible to create a macro that can select and delete all of the charts in a workbook. Regardless of their names? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete a sheet and access charts | Excel Worksheet Functions | |||
Delete ALL Charts in a WorkSheet (VB) | Charts and Charting in Excel | |||
How can I delete a macro when the Delete button is not active? | Excel Worksheet Functions | |||
How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) |