LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 81
Default 2003 vba to hide two grouped charts, works in 2007 but not in 2003

Hi,
Sorry I've copied this over from my post in the Charting newsgroup since
there's not much activity there.
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vba to hide two grouped charts in 2003 - doesn't work Harold Good Charts and Charting in Excel 0 December 17th 09 09:03 PM
VBA errors in 2007 (works fine in 2003) Horatio J. Bilge, Jr. Excel Discussion (Misc queries) 14 September 6th 09 12:46 PM
Works in 2007 but not 2003 teepee[_3_] Excel Discussion (Misc queries) 9 November 25th 08 08:53 AM
sortTable works in 2003 but not in 2007 Marcello Excel Programming 4 March 6th 07 12:24 PM
Hide Row macro works in 2002 but not 2003 Gooser555 Excel Programming 3 February 16th 05 10:17 PM


All times are GMT +1. The time now is 11:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"