Hi Excel Fans,

I have been trying to find the right syntax to simply show or hide a few sheets in a workbook. I have been pouring over google trying to find the right code but now I am at a lost. If anyone can give me some input that would be great.

Cheers
April 

Private Sub ee_toggle_Click()
  If ee_toggle.Value = True Then
     ee_toggle.Caption = "Hide Excel Engine"
    Worksheets("Lists", "Engine").Visible = True
  Else
     ee_toggle.Caption = "Show Excel Engine"
     Worksheets("Lists", "Engine").Visible = False
  End If
End Sub