View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BrownTing BrownTing is offline
external usenet poster
 
Posts: 1
Default 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