Hi everybody,
I created a number of charts as independent worksheets in a workbook, and I want to zoom them to the same magnification. This should be fairly straight-forward using the code

"ActiveWindow.Zoom = 125"

However, the charts always resizes to "fit-to-window" every time I click on them after it's done - I have to manually set them to the correct magnification, which is really annoying.
I've tried writing the above code (ActiveWindow.Zoom = 125) in several different ways such as a sub/private sub, or inserting it at the time of creating the charts/by the time the charts are created, but none of them was helpful.

Anybody have a clue??
Thanks very much in advance!