C'est après aplliquer cette macro et après la sauvegarde que ça ne mlarche plus :
Sub TEST_IMPR_ETIQ_NYLON()
' TEST de la cellule
If Range('D8') = '' Then
MsgBox ('VERIFIER LA SAISIE')
Exit Sub
End If
'Sélectionner et copier la ligne corespondant à la valeur de la cellule D8
Dim c As Range, blnOK As Boolean, strTest As String
strTest = Sheets('MENU_IMPRESSION').Range('D8')
blnOK = False
For Each c In Sheets('Base de donnée').Range('B2:B65536')
If c = strTest Then
blnOK = True
Exit For
End If
Next
If Not blnOK Then
Exit Sub
End If
Sheets('Base de donnée').Activate
Sheets('Base de donnée').Rows(c.Row).Select
Selection.Copy
Sheets('ATTENTE').Activate
Range('D11').Select
Application.ScreenUpdating = False
'Coller la ligne sur la feuille TAMPON
Sheets('TAMPON').Select
Range('A1').Select
ActiveSheet.Paste
'Mets la bonne police de nettoyage
Range('H1').Select
With Selection.Font
.Name = 'SL Wash'
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
'Choix du format de l'étiquette entre nylon et autocolante
If Sheets('tampon').Range('A1') = 'SOIE' Then
Sheets('ETIQUETTE_NYLON').Select
Rows('2:24').Select
Selection.RowHeight = 10.5
Range('A1').Select
Columns('A:A').Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
Selection.Borders(xlEdgeLeft).LineStyle = xlNone
Selection.Borders(xlEdgeTop).LineStyle = xlNone
Selection.Borders(xlEdgeBottom).LineStyle = xlNone
Selection.Borders(xlEdgeRight).LineStyle = xlNone
Selection.Borders(xlInsideVertical).LineStyle = xlNone
Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
With Selection
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.ShrinkToFit = False
.MergeCells = False
End With
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.ShrinkToFit = False
.MergeCells = False
End With
'bug ici
Range('21:24,2:19').Select
Range('A19').Activate
Selection.Font.Bold = True
With Selection.Font
.Size = 7
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
Range('A20').Select
With Selection.Font
.Name = 'SL Wash'
.Size = 12
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
With Selection.Font
.Name = 'SL Wash'
.Size = 11
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
Rows('20:20').RowHeight = 18
Range('A1').Select
Sheets('MENU_IMPRESSION').Select
Application.ScreenUpdating = True
Sheets('ETIQUETTE_NYLON').Copy
Range('A1:A24').Select
Selection.Copy
Range('A1:A24').Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Range('A1').Select
Application.CutCopyMode = False
Exit Sub
End If
If Sheets('tampon').Range('A1') = 'PAP' Then
Sheets('ETIQUETTE_NYLON').Select
Rows('2:24').Select
Selection.RowHeight = 10.5
Range('A1').Select
Columns('A:A').Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
Selection.Borders(xlEdgeLeft).LineStyle = xlNone
Selection.Borders(xlEdgeTop).LineStyle = xlNone
Selection.Borders(xlEdgeBottom).LineStyle = xlNone
Selection.Borders(xlEdgeRight).LineStyle = xlNone
Selection.Borders(xlInsideVertical).LineStyle = xlNone
Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
With Selection
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.ShrinkToFit = False
.MergeCells = False
End With
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.ShrinkToFit = False
.MergeCells = False
End With
'bug ici
Range('21:24,2:19').Select
Range('A19').Activate
Selection.Font.Bold = True
With Selection.Font
.Size = 7
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
Range('A20').Select
With Selection.Font
.Name = 'SL Wash'
.Size = 12
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
With Selection.Font
.Name = 'SL Wash'
.Size = 11
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
Rows('20:20').RowHeight = 18
Range('A1').Select
Sheets('MENU_IMPRESSION').Select
Application.ScreenUpdating = True
Sheets('ETIQUETTE_NYLON').Copy
Range('A1:A24').Select
Selection.Copy
Range('A1:A24').Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Range('A1').Select
Application.CutCopyMode = False
Exit Sub
End If
If Sheets('tampon').Range('A1') = 'CHAUSSURE' Then
Sheets('ETIQUETTE_AUTOCOLLANTE').Select
Range('A1:B9').Select
Selection.Interior.ColorIndex = xlNone
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
Selection.Borders(xlEdgeLeft).LineStyle = xlNone
Selection.Borders(xlEdgeTop).LineStyle = xlNone
Selection.Borders(xlEdgeBottom).LineStyle = xlNone
Selection.Borders(xlEdgeRight).LineStyle = xlNone
Selection.Borders(xlInsideVertical).LineStyle = xlNone
Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
With Selection.Font
.Name = 'Arial'
.Size = 5
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
With Selection
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlBottom
.Orientation = 0
.AddIndent = False
.ShrinkToFit = False
End With
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.Orientation = 0
.AddIndent = False
.ShrinkToFit = False
End With
Selection.Font.Bold = False
Selection.Font.Bold = True
Rows('1:9').Select
Selection.RowHeight = 9.75
Range('A1:B9').Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
Selection.Borders(xlInsideVertical).LineStyle = xlNone
Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
Sheets('MENU_IMPRESSION').Select
Application.ScreenUpdating = True
Sheets('ETIQUETTE_AUTOCOLLANTE').Copy
Range('A1:B9').Select
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Range('A11').Select
Application.CutCopyMode = False
Exit Sub
End If
End Sub