Excel VBA

**void** · 26-03-2009

I want to copy a sheet from a workbook to another workbook without linking. A late copy and paste graphics and value (which can be transformed into a picture if needed) in a workbook created for the occasion (and possibly not registered or named or anything)

Code:

Private Sub CommandButton1_Click () 
UserForm2.Hide 
Sheets ("Export"). Copy 
End Sub

This works but the copy actually contains links to the original, which I do not want to.

**Gunilla** · 26-03-2009

My proposal:

Move a sheet
Check "Create a copy"
Copy the newly copied sheet
Clear the value

**void** · 26-03-2009

This is nice, but I need that it happens in VBA, as the title of the topic suggests.

**XSI** · 26-03-2009

Code:

Sub Macro1 () 
  ' 
  'Macro1 Macro 
  'Macro recorded 15/07/2008 by the  
  ' 
    Sheets ("Sheet1").Select 
    Sheets ("Sheet1").Copy  
  End Sub

Or for an already existing workbook:

Code:

Sub Macro1 () 
  ' 
  'Macro1 Macro 
  'Macro recorded 15/07/2008 by the  
  ' 
    Sheets ("Sheet1").Select 
    Sheets ("Sheet1").Copy Before: = Workbooks ("destination.xls).Sheets(1) 
  End Sub