Chart – sized with window (2000)

Topic

New Reply

I created and distributed a worksheet with a chart imbedded in another chart sheet. It was returned to me with the chart sheet changed to “sized with window”. My problem is that I can’t turn off that option. Any hints.

Reply | Quote

Replies

Hi,
I take it you’re saying that clicking View-Sized with window doesn’t turn off the sizing? If so, is there any code in the workbook that might be reinstating the setting? (as far as I’m aware Protection wouldn’t affect this setting).

Reply | Quote

Your assumption is correct and there isn’t any code turning it on.

Reply | Quote

If you look at the chart sheet’s properties in the VBEditor window, can you change the SizeWithWindow property there?

Reply | Quote