How to Hide and Unhide tabs according to cell criteria.
Solved/Closed
SimplemindedDwight
Posts
3
Registration date
Monday 20 April 2015
Status
Member
Last seen
19 May 2015
-
19 May 2015 à 12:10
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 20 May 2015 à 02:03
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 20 May 2015 à 02:03
Related:
- How to Hide and Unhide tabs according to cell criteria.
- How to hide steam comments - Guide
- How to close tabs on android - Guide
- How to hide videos on youtube - Guide
- How to hide subscriber count - Guide
- Potplayer hide controls - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Contributor
Last seen
6 September 2024
262
20 May 2015 à 02:03
20 May 2015 à 02:03
Hello SMD,
In the worksheet module (right click on the "Rent to Own" sheet" and select "view code") then place this code in the big white field:-
As you can see from the code, the data validation box is assumed to be in cell A1. Change this to suit yourself.
To unhide, right click on any tab and select "unhide" or, if you prefer, place this code in a standard module:-
I hope that this helps.
Cheerio,
vcoolio.
In the worksheet module (right click on the "Rent to Own" sheet" and select "view code") then place this code in the big white field:-
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A1") <> "RTO" Then
Sheets("Rent to Own").Visible = False
End If
End Sub
As you can see from the code, the data validation box is assumed to be in cell A1. Change this to suit yourself.
To unhide, right click on any tab and select "unhide" or, if you prefer, place this code in a standard module:-
Sub Unhide()
Sheets("Rent to Own").Visible = True
Sheets("Rent to Own").Select
End Sub
I hope that this helps.
Cheerio,
vcoolio.
