Excel VBA

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.

My proposal:

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

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

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

---