excel 2003 to 2007 changes document dimensions

F

feh

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2003 works, 2007 doesn't: "Method 'Select' of object 'Shape' Fail 2
Zoom problem with shapes in Excel 2007 2
Using Excel VBA to create shape in Word 4
excel shape xy poisiton in A4 paper 0
Grouping Shapes in 2007 3
How do you work with simple arrays in VBA? 6
Excel 2007 Not Drawing Correctly 2
2003 vs 2007 Shape Selection Error 3

Top