Conditional hide rows in multiple sheets
Solved/Closed
issa
-
Apr 25, 2010 at 01:32 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 25, 2010 at 08:22 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 25, 2010 at 08:22 PM
Related:
- Conditional hide rows in multiple sheets
- How to hide app store on ipad - Guide
- Sheets right to left - Guide
- How to lasso multiple objects in photoshop - Guide
- How to see hide story on instagram - Guide
- Quicktime hide controls - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 25, 2010 at 08:22 PM
Apr 25, 2010 at 08:22 PM
Open the VBE
click on you master sheet
and paste this code
click on you master sheet
and paste this code
Private Sub Worksheet_Change(ByVal Target As Range) Dim bHide As Boolean If Target.Column <> 2 Then Exit Sub bHide = True If (CStr(Target) <> "0") Then bHide = False For Each Sheet In Sheets If Sheet.Name = ActiveSheet.Name Then GoTo Next_Sheet Sheets(Sheet.Name).Rows(Target.Row).Hidden = bHide Next_Sheet: Next End Sub