Prev: How To Chart A Formula in Excel 2007
Next: Excel 2007
From: Harold Good on 17 Dec 2009 16:03
Hi,
I have the following code which works fine in 2007. But since I have
some users that still use 2003, when I save the spreadsheet in 2003 xls
format, this code will no longer work. I found that when I ungroup the
two charts, then it works fine.

Do I need to use code to Ungroup them first, or is there a simple solution?

Thanks,
Harold

Sub Hide_Two_Charts()
Sheets("Budget").ChartObjects("Chart 130").Visible = False
Sheets("Budget").ChartObjects("Chart 190").Visible = False
End Sub
 | 
Pages: 1
Prev: How To Chart A Formula in Excel 2007
Next: Excel 2007