I have a pivot table with 16 rows at the bottom containing financial info that the user can Hide or Unhide (using buttons). The problem is, when these rows are hidden, as the user pulls page flds down into the column area, it bumps down the bottom rows that should always be visible into the hidden area - resulting in rows that need to be shown but are not. This is my code behind the "Hide Financials" "Unhide Financials" buttons. How can I fix this so that as the page flds are pulled down, it somehow adjusts and shows all the rows it's supposed to. Hopefully I've explained this clearly enough and someone has a simple fix. I am not well versed in Excel. Thanks in advance for any help.
Sub UnhideFinancial_Click()
Rows("53:69").Select
Selection.EntireRow.Hidden = False
Range("D3").Select
End Sub
Sub HideFinancial_Click()
Rows("53:69").Select
Selection.EntireRow.Hidden = True
Range("D3").Select
End Sub
Linda in MN
Sub UnhideFinancial_Click()
Rows("53:69").Select
Selection.EntireRow.Hidden = False
Range("D3").Select
End Sub
Sub HideFinancial_Click()
Rows("53:69").Select
Selection.EntireRow.Hidden = True
Range("D3").Select
End Sub
Linda in MN