Hi,
here are 2 simple macros to hide and unhide worksheets.
You need to change the sheet names to that you want to Hide or Unhide name.
Code:
Sub Hide_Worksheet()
If ActiveSheet.Cells(2, 5).Text = "2" Then
Sheets("Sheet2").Visible = False
End If
End Sub
Code:
Sub UnHide_Worksheet()
If ActiveSheet.Cells(2, 5).Text = "2" Then
Sheets("Sheet2").Visible = True
End If
End Sub