Sub Creation_Classeur()
Dim Wb01 As Workbook
Dim Wb02 As Workbook
Dim NbFeuilles01 As Integer
Dim NbFeuilles02 As Integer
Dim I As Integer
Set Wb01 = ThisWorkbook
Set Wb02 = Workbooks.Add
NbFeuilles01 = Wb01.Sheets.Count
NbFeuilles02 = Wb02.Sheets.Count
If NbFeuilles02 < NbFeuilles01 Then
Wb02.Sheets.Add Count:=NbFeuilles01 - NbFeuilles02
End If
For I = 1 To Wb01.Sheets.Count
Wb01.Sheets(I).Cells.Copy
Wb02.Sheets(I).Range("A1").PasteSpecial Paste:=xlValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Wb02.Sheets(I).Range("A1").PasteSpecial Paste:=xlFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Wb02.Sheets(I).Name = Wb01.Sheets(I).Name
Wb02.Sheets(I).PageSetup.FitToPagesWide = Wb01.Sheets(I).PageSetup.FitToPagesWide
Wb02.Sheets(I).PageSetup.PrintArea = Wb01.Sheets(I).PageSetup.PrintArea
Wb02.Sheets(I).PageSetup.FitToPagesTall = Wb01.Sheets(I).PageSetup.FitToPagesTall
Next I
End Sub