I need to follow up on Peter's post, but let me give you some advice based
on many hours of unsuccessful trials. I have had no joy when trying to deal
with mouse and screen coordinates in a chart sheet when SizeWithWindow is
false. (I can make it work flawlessly in an embedded chart and in a chart
sheet that sizes to the window.) There is no coordinate consistency in VBA
for this, since the window can be scrolled, and there's no way to get the
scroll position. Perhaps Peter's API approach might help with that, but I
can predict it will be a tedious frustrating process to work out.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"MrT" wrote in message
...
Hi there,

Here is a problem with no solution so far:
- Create an empty chart, and make it be a chart sheet
- Then add a rectangle on it
- If ActiveChart.SizeWithWindow is set to false, how do you know the
screencoordinates of the Rectangle ? Left will only give you the position
inside the chartarea, and ChatArea.Left is 4 (which is not relative to the
screen)?

Thanks,

MrT