Hi everybody,
I created a number of charts as independent worksheet in a workbook, and I want to zoom them to the same magnification in the end. 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, 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 helped solving the issue.
Anybody have a clue??
Thanks in advance!
I created a number of charts as independent worksheet in a workbook, and I want to zoom them to the same magnification in the end. 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, 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 helped solving the issue.
Anybody have a clue??
Thanks in advance!
