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 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - May 20, 2015 at 02:03 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - 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 unhide bookmarks bar opera gx - Guide
- How to see hide story on instagram - Guide
- How to delete icloud tabs - Guide
- How to close tabs on android - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
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.
