Command Button to Show Hidden pivot charts

Hello All ,

Would anyone be able to help me with the following query?

I would like to create a macro that unhides hidden pivot tables within an excel worksheet. for example:

If commanbutton4 is clicked then pivot chart4 is unhidden. The pivot charts are currently being grouped in efforts to hide them and I want to have 4 buttons for each pivot.

So if the user wants to view pivot table 4 they click the commandbutton4 assigned to pivot table 4. If they want pivot table 1 --they click comandbutton1, then pivot table 4 becomes hidden once again (if it has been selected) and pivot table 1 is unhidden.

So far I have this:

Private Sub CommandButton4_Click()
 
Rows("45:74").EntireRow.Hidden = False
End Sub

However I would like the rows to be hidden once another pivot is chosen?

I tried recording a macro fort his but it doesn’t work.


Can anyone please help me begin this process?