Change properties to

not move or size

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Christof" wrote in message
...
Hi,

I have a tool in excel/VBA that draws shapes on the sheets based on the
information found.

When I run the same tool in 2007, the shapes are all in the wrong place,
because contrary to previous versions, Excel 2007 does not take the zoom
setting into account. As a result, previously, the coordinates of cells
and
shapes were the same.
Now, the coordinate system of shapes is relative to the window position
instead of the window content. This means that shapes are always drawn on
the
same place of your screen, independant of the zoom. Only when the zomm is
100%, the coordinates are OK.

also, when I run the tool in 2003 (shapes placed OK), save and open in
2007,
the shapes are not in the correct place any more, they moved.

Does anybody know more about this issue? Is there a setting which governs
this?
Is this a documented bug?

thanks,
Christof