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

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

Don,

I have the same problem as Christof and the solution you propose doesn't
work for me.
I have around 46 textboxes placed to each other and the first 40 are
displayed correctly, but then the other six are just placed upon the last one.
I checked the coordinates and they're ok.
I tried the following:
myS.Placement = xlFreeFloating
myS.Placement = xlMove
myS.Placement = xlMoveAndSize

But none of the three options above gave me a good result at 50% zoom.
When the zoom is 100%, evertything is OK.

I can set the zoom at 100% at the beginning and afterwards back to the zoom
it was, but that's a workaround, NOT a solution.

Any other ideas?

Thanks,
Alain

"Don Guillett" wrote:


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