Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to Use 1 Button to toggle On or Off
This works perfectly:
Sub HideZeroRows() 'to hide calculated items that equal zero 'hide worksheet rows that contain zeros 'by John Green Dim rRow As Range Application.ScreenUpdating = False For Each rRow In ActiveSheet _ .PivotTables(1).DataBodyRange.Rows If Application.Sum(rRow) = 0 Then rRow.EntireRow.Hidden = True End If Next rRow Application.ScreenUpdating = True End Sub There is a Macro that will **If no rows are hidden - Run the Macro and If Rows Are hidden UnHide All Rows. But how is this done? Any assistance appreciated.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to Use 1 Button to toggle On or Off
Include this line:
Rows.Hidden = False It will unhide all rows -- Gary''s Student - gsnu200759 "Jim May" wrote: This works perfectly: Sub HideZeroRows() 'to hide calculated items that equal zero 'hide worksheet rows that contain zeros 'by John Green Dim rRow As Range Application.ScreenUpdating = False For Each rRow In ActiveSheet _ .PivotTables(1).DataBodyRange.Rows If Application.Sum(rRow) = 0 Then rRow.EntireRow.Hidden = True End If Next rRow Application.ScreenUpdating = True End Sub There is a Macro that will **If no rows are hidden - Run the Macro and If Rows Are hidden UnHide All Rows. But how is this done? Any assistance appreciated.. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to Use 1 Button to toggle On or Off
Gary's Student : Thanks, but I do not know how to use what you are suggesting.
So far I have the following: (Which is not working) - It call my Macro Sub HideUnHideRow() ' This is my Toggle Macro attached to a forms button Dim bHidden As Boolean If ActiveSheet.Cells.EntireRow.Hidden = False Then HideZeroRows ' The Main Macro bHidden = True Else ActiveSheet.Cells.EntireRow.Hidden = True End If bHidden = Not bHidden End Sub "Gary''s Student" wrote: Include this line: Rows.Hidden = False It will unhide all rows -- Gary''s Student - gsnu200759 "Jim May" wrote: This works perfectly: Sub HideZeroRows() 'to hide calculated items that equal zero 'hide worksheet rows that contain zeros 'by John Green Dim rRow As Range Application.ScreenUpdating = False For Each rRow In ActiveSheet _ .PivotTables(1).DataBodyRange.Rows If Application.Sum(rRow) = 0 Then rRow.EntireRow.Hidden = True End If Next rRow Application.ScreenUpdating = True End Sub There is a Macro that will **If no rows are hidden - Run the Macro and If Rows Are hidden UnHide All Rows. But how is this done? Any assistance appreciated.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
toggle radio button | Excel Discussion (Misc queries) | |||
Toggle Button | Excel Worksheet Functions | |||
Toggle Button | Excel Discussion (Misc queries) | |||
Toggle button | Excel Discussion (Misc queries) | |||
Toggle Button | Excel Discussion (Misc queries) |