K
Keith Dixon-Roche
I compiled a VBA macro that draws pictures on one of my Excel 2003
spreadsheets when a Control Button is clicked.
When the Control Button is clicked after loading the same file into
Excel-Office 2007, the straight lines draw correctly but the circles don't.
The function "Set Arc = efitt.Shapes.AddShape()" draws the circle with the
correct radius, but the start and stop points are different in 2007.
Anybody know why and how to correct it? other than rewriting the code -
there is an awful lot of it and most of it is determined by formulas. So I
would prefer to tick the appropriate box if there is one.
spreadsheets when a Control Button is clicked.
When the Control Button is clicked after loading the same file into
Excel-Office 2007, the straight lines draw correctly but the circles don't.
The function "Set Arc = efitt.Shapes.AddShape()" draws the circle with the
correct radius, but the start and stop points are different in 2007.
Anybody know why and how to correct it? other than rewriting the code -
there is an awful lot of it and most of it is determined by formulas. So I
would prefer to tick the appropriate box if there is one.