Public DernFeui As Object
'
Private Sub Workbook_Open()
Workbook_SheetActivate ActiveSheet
End Sub
'
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If Sh.Name <> Feuil1.Name Then Set DernFeui = Sh: Feuil1.[Z1].Value = "Retour à """ & Sh.Name & """"
End Sub