Command Button to Show Hidden pivot charts

[Chioma1975]

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:

Please Login or Register  to view this content.

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?

[fredlo2010]

where are you Pitvot tables located? can you provide a sample of the workbook?

Thanks