vba to hide two grouped charts in 2003 - doesn't work

H

Harold Good

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

position of chart on page moves when outline expands 2
Update "centerheader" code running slowly need help speeding up 7
help on vba macro to put multiple charts on multiple worksheets based on table in each worksheet 0
Excel 2003 code to use instead of ChartObjects 4
Charting macro for creating multiple charts on multiple sheets 0
chart objects top 1
Charts from 2003 not working in 2007 2
Copying Excel 2007 Charts as picture (as seen on screen) 1

Top