Jim
It is acknowledged that this is 'broken' in XL2007. The charts and drawing
objects (now SmartArt) are shared across apps (Word/Excel/PowerPoint), so it
will take an SP or v.next I suspect for the object model/recorder to catch
up properly. It always becomes an issue when different teams get involved
across apps
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog:
www.nickhodge.co.uk/blog/
FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk
"Jim Rech" wrote in message
...
I probably spend more time addressing issues related to
drawingobjects/shapes when trying to get my apps to run in XL07 than
anything else. Strangely enough though your code runs fine for me. Even
the recorder records the same code.
--
Jim
"teepee" wrote in message
...
| Hello
|
| Could any knowledgable person please help.
|
| I try to run a VBA code that woks fine in Excel 2003 and it crashes in
2007.
|
| The offending line is
|
| ActiveSheet.ChartObjects("Chart 542").Activate
|
| What could possibly be wrong with that?
|
| Is it me or is Excel 2007 not there yet?
|
|