Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 81
Default vba to hide two grouped charts in 2003 - doesn't work

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
Reply
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
How to hide and show a grouped column via VBA code? Michiel via OfficeKB.com Excel Discussion (Misc queries) 3 April 24th 23 07:46 PM
Grouped Items won't Stay Grouped When Moving Object Heather02 Excel Discussion (Misc queries) 0 February 12th 09 07:08 PM
Shortcut for hide/show detail in grouped columns/rows Corey Excel Discussion (Misc queries) 1 November 20th 07 12:06 AM
Hide Charts Sandy Charts and Charting in Excel 0 August 13th 07 11:24 AM
Column Charts - stacked and grouped jtd1 Charts and Charting in Excel 2 April 10th 05 10:48 PM


All times are GMT +1. The time now is 03:56 AM.

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"