View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default Excel 2007 VBA problem

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?
|
|