View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karoo News[_2_] Karoo News[_2_] is offline
external usenet poster
 
Posts: 17
Default VBA Needed to remove graphs

Hi all I have in a workbook vba code that creates a graph when a sheet is
activated. These happen on sheets 4 to 42. The reason I do this is to keep
the file size small as it is used on Excel 97. The problem i have is trying
to remove these graphs when the sheet deactivates due to the new sheet
activation code working. Is there a simple quick code that can remove any
graphs that are in pages 4 to 42 that I could put in say sheet activation
before the new graph code!

Hope this makes sense!

Regards
Neil