Thread: Hiding charts
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Hiding charts


Some good advice here...
http://www.cpearson.com/excel/newposte.htm

Assume you are referring to a fairly recent version of Excel,
(but not xl2007), running on Windows.
Also that the chart is an embedded chart on a worksheet, not a
separate chart sheet, then...

With ActiveSheet.ChartObjects("MyChartName")
.Visible = Not .Visible
End With
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"dan"
wrote in message
Please help me with a vba program that will hide and show on command.
Thanks