Private FeuilleActive As Worksheet
Private Sub Workbook_Open()
If ActiveSheet.Name = Me.Worksheets(1).Name Then
Me.Worksheets(2).Activate
Else
Set FeuilleActive = ActiveSheet
End If
End Sub
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If Sh.Name = Me.Worksheets(1).Name Then
FeuilleActive.Activate
Else
Set FeuilleActive = ActiveSheet
End If
End Sub