Re,
Le code à mettre dans Thisworkbook
Dim nomfeuille As String
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Target, Range("C1")) Is Nothing Then
Cancel = False
Target.Value = nomfeuille
End If
Cancel = True
End Sub
Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
nomfeuille = Sh.Name
End Sub
Vous avez des codes dans chacune des feuilles que vous pouvez supprimer et le remplacer par ce code unique dans thisworkbook :
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Dim choix
Dim f As Worksheet
choix = ""
For Each f In Worksheets
If f.Name <> "Template" Then choix = choix & f.Name & ","
Next
With ActiveSheet.Range("C1").Validation
.Delete
.Add xlValidateList, Formula1:=choix
End With
End Sub
Cordialement