Copy sheet problem in Excel 2007

Reinhard Thomann

Guest

Posts: n/a

7th Mar 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

« Selection.width / .height / .left / .top from cell refor userform | How do I write a looping in VBA in Excel? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
The easiest way to copy a sheet of formulas! (Excel 2007)	Robert Crandal	Microsoft Excel Programming	1	17th Dec 2009 08:31 PM
Excel 2007 copy sheet with controls not working	Bruno Q.	Microsoft Excel Programming	2	10th Sep 2008 11:56 PM
Excel 2007 move/copy sheet error	Terry B	Microsoft Excel Discussion	8	21st Mar 2008 01:31 PM
Excel 2007 Copy Sheet with Tables	TKS_Mark	Microsoft Excel Crashes	0	3rd Jan 2008 10:33 PM
Excel 2007 slow to copy entire sheet	=?Utf-8?B?bWptYXR0b3g=?=	Microsoft Excel Misc	3	28th Mar 2007 08:30 PM