Sub RechercheFacture()
[COLOR=blue]If Sheets(nomfeuil).Sheets("Accueil").Range("L12") = 0 Then Exit Sub
[/COLOR]'
ActiveSheet.Shapes("Button 10").Select
Sheets("Accueil").Select
Range("M19").Select
Application.Run ("'GESTION STOCK.xls'!Openarchives")
Windows("Archives.xls").Activate
Dim nomfeuil As String
nomfeuil = Workbooks("GESTION STOCK.xls").Sheets("Accueil").Range("L12")
Sheets(nomfeuil).Select
End Sub