I have €œinherited€� a number of legacy worksheets that use, I believe, the pre
Excel 97 via VBA drawing object model to plot complex diagrams on a number of
sheets.

These work perfectly in all versions of Excel up and to Excel 2003, but now
give problems when running under Excel 2007 (although the VBA compiles OK) .
In Excel 2007 the positioning and rotation of the arcs (and to some extent
other drawing items).
are totally different in Xl 2007

A simply example of the code I have is show below:

Sub DrawArc()
With ActiveSheet.Arcs.Add(10, 10, 200, 200)
With .Border
.LineStyle = xlContinuous
.Weight = xlThin
End With
End With
End Sub

If I run the above example in Excel 2003, the arc starts in cell A1 and ends
in E14, but in Excel 2007 it starts in cell E1 and ends in I14. Effectively
the drawing routines in the worksheets are now rendered useless under 2007
because of this.

Is this a known compatibility issue? And my question really is, is there a
workaround or am I faced with having to rewrite the code, (which is quite a
major task), to get make the worksheets useable under 2007?