Option Explicit
Option Base 1
Option Compare Text
Dim Wk As Workbook
Dim maCel As Range
Dim i As Integer
Dim Valo As String
Sub Cacher()
Set Wk = ThisWorkbook
'Cellule où contient la valeur
Set maCel = Range("A1")
'Valeur pour laquelle la feuille doit être cachée
Valo = "Toto"
On Error Resume Next
For i = 1 To Wk.Sheets.Count
If Wk.Sheets(i).Range(maCel.Address).Value = Valo Then Wk.Sheets(i).Visible = False
Next i
End Sub
Private Sub Worksheet_Calculate()
Application.ScreenUpdating = False
On Error GoTo Fin
For i = 1 To Sheets.Count
If Sheets(i).Name Like "Relevé de production" & "*" Then Sheets(i).Visible = False
If Range("G3").Value <> "" Then If Sheets(i).Name Like "* " & Range("G3").Value Then Sheets(i).Visible = True
Next i
Fin:
Application.ScreenUpdating = True
End Sub