Tab: Hide - unhide

[gheyman]

I am trying to have a button on a separate tab, where when clicked it hides a specific tab or unhides it if its already hidden. Is there an If type statement that can determine if a tab is visible or not?

Sub TabVisibility_PROP_MASTER_TABLE()
    Sheets("PROP_MASTER_TABLE").Visible = True


End Sub
[code/]

 

[Fluff]

How about

With Sheets("PROP_MASTER_TABLE")
   .Visible = Not .Visible
End With

 

[gheyman]

Perfect. Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.