excel 2003 to 2007 changes document dimensions
 

X-No-Archive:

Hi,

I have a workbook developed in Excel 2003. It draws some shapes based
on button clicks using shapes.addshape method. The .top and .left
parameters of the shapes.addshape method are hard coded.

After upgrading to Excel 2007, the top and left parameters put the
shape in a very different location relative the worksheet.

It draws the shape the correct size, but puts it in the wrong
location.

Can anyone suggest how to account for the difference and make sure
that the shapes are drawn in the same location regardless of which
version of Excel a user has installed?

TIA,
Charles