Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting All charts using VB
Hi Everyone, Essentially I have made a program that produces charts as a new worksheet (Chartsheet); however I have some code that works on the number of worksheets produced and will mess up when more charts are added. I cannot modify the code nor produce charts inside of a worksheet but this will cause more problems. My question: Does anyone know a command in Visual Basic that deletes charts produced as worksheets (chartsheet)? -Identify a charts produced as a worksheets (tab) -delete charts (without a specific tab name) (Ex. Chart 1, Chart 2…..ect) -delete all charts without referring to their name. Thanks -- BrownTing ------------------------------------------------------------------------ BrownTing's Profile: http://www.excelforum.com/member.php...o&userid=34919 View this thread: http://www.excelforum.com/showthread...hreadid=560678 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting All charts using VB
Try
Dim CH As Chart Application.DisplayAlerts = False For Each CH In ThisWorkbook.Charts CH.Delete Next CH Application.DisplayAlerts = True -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "BrownTing" wrote in message ... Hi Everyone, Essentially I have made a program that produces charts as a new worksheet (Chartsheet); however I have some code that works on the number of worksheets produced and will mess up when more charts are added. I cannot modify the code nor produce charts inside of a worksheet but this will cause more problems. My question: Does anyone know a command in Visual Basic that deletes charts produced as worksheets (chartsheet)? -Identify a charts produced as a worksheets (tab) -delete charts (without a specific tab name) (Ex. Chart 1, Chart 2...ect) -delete all charts without referring to their name. Thanks -- BrownTing ------------------------------------------------------------------------ BrownTing's Profile: http://www.excelforum.com/member.php...o&userid=34919 View this thread: http://www.excelforum.com/showthread...hreadid=560678 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting All charts using VB
Hi,
This will delete all chartsheets. Activeworkbook.Charts.delete Cheers Andy BrownTing wrote: Hi Everyone, Essentially I have made a program that produces charts as a new worksheet (Chartsheet); however I have some code that works on the number of worksheets produced and will mess up when more charts are added. I cannot modify the code nor produce charts inside of a worksheet but this will cause more problems. My question: Does anyone know a command in Visual Basic that deletes charts produced as worksheets (chartsheet)? -Identify a charts produced as a worksheets (tab) -delete charts (without a specific tab name) (Ex. Chart 1, Chart 2…..ect) -delete all charts without referring to their name. Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting All charts using VB
thanks!!! they both work -- BrownTing ------------------------------------------------------------------------ BrownTing's Profile: http://www.excelforum.com/member.php...o&userid=34919 View this thread: http://www.excelforum.com/showthread...hreadid=560678 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting SeriesCollections in charts | Excel Programming | |||
Charts should not be resized when deleting rows/columns. | Charts and Charting in Excel | |||
Moving/deleting pictures within charts via macros | Excel Programming | |||
Automatically Confirm Deleting Charts | Excel Programming | |||
Deleting charts on a sheet | Excel Programming |