Martin, Excuse me while I freak out! Wasn't my choice to go to 2007! I have
a couple thousand lines of VB to create a quarterly report of about fourty
charts to trend/avg, over years of history, about 60 metrics. Long story why
I'm using VB/Excel (inherited it several years ago, data comes to me in
Excel, and haven't had time to change environments (IDL anyone?)). And I
sure don't have time this quarter. ok, end of freak out.

Can't be I'm the first person to ask this, but I didn't find related Q/A in
these forums, or anywhere on microsoft.com Appreciate hints, guidance to
resource/discussions on the known issues. The environment looks different
but the VB version is the same (under <Help<About. Is this
..excel.programming where I should find such Q/A or am I in the wrong place.

"Martin Brown" wrote:

The short answer is *DON'T* XL2007 is fubar compared to 2003 or 2002.

Charts and graphical object are screwed up in 2007. You can fork the
code to make a 2007 compatible version but there are gratuitous and
arbitrary differences in the definition of shapes in the newest version.
They would be amusing quirks in a graduate students end of term project,
but not in a commercial product. Good luck you will need it!

Regards,`
Martin Brown