Скачать или смотреть Hide and Show worksheet based on cell selected Value

Hide and Show worksheet based on cell selected Value. How to hide worksheets. How to unhide worksheets using VBA. Set code to run with changes on your sheet. How to use the Case function in VBA. Check out my templates page for free and purchased templates https://www.easyexcelanswers.com/temp...

Code

Private Sub Worksheet_Change(ByVal Target As Range)
'Application.Volatile



Select Case Worksheets("Sheet1").Range("C3").Value
Case "One"
Worksheets("A").Visible = True
Worksheets("B").Visible = True
Worksheets("c").Visible = True
Worksheets("D").Visible = False
Worksheets("e").Visible = False
Worksheets("f").Visible = False
Case "Two"
Worksheets("A").Visible = False
Worksheets("B").Visible = False
Worksheets("c").Visible = False
Worksheets("D").Visible = True
Worksheets("e").Visible = True
Worksheets("f").Visible = True
Case "Three"
Worksheets("A").Visible = True
Worksheets("B").Visible = True
Worksheets("c").Visible = False
Worksheets("D").Visible = False
Worksheets("e").Visible = False
Worksheets("f").Visible = True
End Select
End Sub

For more help visit my website http://www.easyexcelanswers.com or email me at [email protected].

I can customize this Excel application for your exact needs for a fixed price of $50. The work is normally returned within 24hrs.

I am able to provide online help on your computer at a reasonable rate.

MY videos are all created on Camtasia.
http://send.onenetworkdirect.net/z/58...


Follow me on Facebook
  / easyexcel.answers