Private Sub CommandButton1_Click()
Dim st As String
Dim sh As Worksheet
Dim shDest As Worksheet
Set sh = ActiveSheet
st = InputBox("Copy feuille " & sh.Name & " vers Feuille :")
If st <> "" Then
On Error GoTo ErrCopy
sh.Copy after:=sh
Set shDest = ActiveSheet
shDest.Name = st
End If
Exit Sub
ErrCopy:
MsgBox "Erreur : " & Err.Number & " " & Err.Description & vbCrLf & "Sur copie " & sh.Name & " vers feuille " & st, vbCritical
End Sub