How to Hide and Unhide tabs according to cell criteria.
Solved/Closed
SimplemindedDwight
Posts
3
Registration date
Monday April 20, 2015
Status
Member
Last seen
May 19, 2015
-
May 19, 2015 at 12:10 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - May 20, 2015 at 02:03 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - May 20, 2015 at 02:03 AM
Related:
- How to Hide and Unhide tabs according to cell criteria.
- How to hide app store on ipad - Guide
- How to know if someone hide their story from you on instagram - Guide
- How to close tabs on android - Guide
- How to unhide bookmarks bar opera gx - Guide
- How to delete icloud tabs - Guide
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
May 20, 2015 at 02:03 AM
May 20, 2015 at 02:03 AM
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.
