When i copy worksheets in Excel 2007 with command
ActiveWorkbook.Sheets(Source).Copy After:=Destination
the copied sheet will lose pictures und diagrams doesn't work.
I use the compatibility file format 97to2003. In Excel 2003 it works fine.

Is this a known problem? Any workarounds?

TIA
Reinhard