Offhand, I'm not sure how I would do this in VBA. None of the scrolling
commands work. I've also had lots of trouble with using mouse click events
in chart sheets. If all I'm doing is getting X and Y from the click (in
whatever arbitrary units) and passing them through to GetChartElement, it's
no big deal, but if I'm trying to actually use the XY values for something,
I quickly reach my boiling point. There's no way I've found to measure where
you're scrolled to, and no way to scroll on your own. And something as
distant as changing default printers will change the way the chart sheet is
portrayed. I would have suggested that you use embedded charts.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
wrote in message
oups.com...
Thanks Jon,
I was hoping for another answer. I have developed lots of VBA code
based on chart pages and this zooming feature was one of the last
things to do. I'm hoping to stay with chart pages if possible.
So another question. Suppose you were forced to use a chartpage and
still use VBA to zoom and see different areas of a magnified chart how
would you do it?
It seems strange to me that I can do this so easy manually , but there
is no capability of doing it in VBA. Do I have to use mouse or
keystroke events to do it?