Excel Chart "Sixed with window" in 2010?

[N1GHTEYES]

This is driving me nuts.
I have an Excel workbook with several sheets, including chart sheets. I have set this up to show several of the sheets in their own windows, including the charts (and some of the rest - mainly as an "input area"). I need to let the user click a point on one of the charts to select a point and change the rest of the display accordingly. I also want him to be able to rearrange the windows, including resizing them, as appropriate, to accomodate deteiled views on his display of interest. This works fine in 2003, with the chart sheets set to "Size to window", but fails when I use it in 2010, as the size to window option seems to be missing.
I need to know: am I just missing the right method? Have they retained this feature and I've just failed to find it? Or have they actually removed it?
If the latter, is there a workaround in code?
I had a look at the chart object. It does have a sizewithwindow property, but when I set this to true in code, although it does not throw an error, it also does not change the state of the property - which remains at "false".

The reason I'm doing it with separate windows (rather than embedding the charts in a sheet with all the other data) is mainly that I need to do so to generate the chart event required to respond to the user chart click.

Any suggestions greatly appreciated.

Thanks,
Tony
p.s. Hi guys - it's been a while...

 

[SkipVought]

Hi,

This seems more a forum707 question.

I'd suggest checking

http://spreadsheetpage.com

I have his Charts for 2003, which has a method for exposing Chart events for ChartObject Objects on a WorkSheet.

I cannot answer the resizing question for 2010.

You might also be able to embed multiple charts in a ChartSheet Object.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[N1GHTEYES]

Thanks Skip. I posted it in slightly modified form over in the VBA forum.
I checked JW's site which confirmed that MS have indeed scrapped Sized with window (SWW) in 2010. Blast.
Your suggestion of embedding the charts and using JW's method to still be able to access the chart events may be my best bet, but I will also consider trying to simulate the SWW property in code instead if I can.
I recall having a bash at accessing embedded sheets a while back, but that was in Office '97, and you mentioned JW's version was for 2003 - I don't know if it will still work in 2010. Have you any idea?
Could you outline what his method was for 2003 please? Or perhaps point me to an example if you know of one?
I will be checking both threads, so if you'd rather respond over on the other, that's fine.

Tony