Please, help me. How to hide Sheet2 if value on Sheet1 range J1 = 1, and show Sheet2 if value on Sheet1 range J1 = 0.
Please, help me. How to hide Sheet2 if value on Sheet1 range J1 = 1, and show Sheet2 if value on Sheet1 range J1 = 0.
Maybe:
Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("J1")) Is Nothing Then Select Case Range("J1").Value Case Is = 1 Sheets("Sheet2").Visible = False Case Is = 0 Sheets("Sheet2").Visible = True End Select End If End Sub
JOHN H. DAVIS, I have tried your code, but nothing done.
Where did you place the code?
Excuse me, JOHN H. DAVIS. Your code works fine. I put it on Sheet1. Thanks so much, JOHN H. DAVIS. Your code works well.
Last edited by putritersenyum; 03-24-2016 at 09:52 AM.
But, please, help me how to apply hide/unhide when change the value using spin button?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks