ExcelBanter - Copy sheet problem in Excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Copy sheet problem in Excel 2007 (https://www.excelbanter.com/excel-programming/384748-copy-sheet-problem-excel-2007-a.html)

Reinhard Thomann

Copy sheet problem in Excel 2007

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

All times are GMT +1. The time now is 06:43 PM.