Option Explicit
Dim TabColor
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Sh.Tab.Color = vbGreen
End Sub
Private Sub Workbook_SheetdeActivate(ByVal Sh As Object)
If TabColor.exists(Sh.CodeName) _
Then Sh.Tab.ColorIndex = TabColor(Sh.CodeName)
End Sub
Private Sub Workbook_Open()
Tab_Color
Sheets("SUIVI").Select
Application.WindowState = xlMaximized
Cells(4 + Month(Date), 2 + Day(Date)).Select
End Sub
Sub Tab_Color()
Dim Sh As Worksheet
Set TabColor = CreateObject("Scripting.Dictionary")
For Each Sh In ThisWorkbook.Sheets
TabColor.Add Sh.CodeName, Sh.Tab.ColorIndex
Next
Set Sh = Nothing
End Sub