Copy sheet problem in Excel 2007

  • Thread starter Reinhard Thomann
  • Start date
R

Reinhard Thomann

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dsofile.dll and Excel 2007 file format 4
Worksheet copying in Excel 2007 3
XL2007 .CodeName bug when copying sheet 5
excel 2003 vs 2007 menu and sheet issues 3
XL2007 .CodeName bug when copying sheet 3
Copy adjacent Sheet and name from a list 42
Drawing in VBA - compatibility between Excel 2003 and 2007 6
first sip of working with range in vba excel 6

Top