Conditional hide rows in multiple sheets
Solved/Closed
issa
-
Apr 25, 2010 at 01:32 PM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Conditional hide rows in multiple sheets
- Copy Rows to multiple sheets based on drop down validation ✓ - Forum - Excel
- Excel split rows into multiple sheets ✓ - Forum - Excel
- Excel delete same row in multiple sheets - Forum - Excel
- Excel conditionally hide rows without vba - Forum - Excel
- Hide rows with zero value in Multiple sheets ✓ - Forum - Excel
1 reply
rizvisa1
Apr 25, 2010 at 08:22 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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