Hidin Pivot Tables

[suzgormley]

Hi,

I have created 5 pivot_tables and I would like to hide the tables and
only show them again when a button is pressed-so I'd like a button that
says "Generate reports by divison" and when its clicked the division
reports appear. Is this possible? Any help would be greatly
appreciated!
Thank you
Suzanne

 

[Guest]

Need a bit more info. Are the pivot tables all on one sheet (a bad idea in my
opinion but...) or are they each on seperate sheets? If seperate sheets then
the button just needs to unhide the required sheet which is easy to do.
otherwise it gets a whole pile more difficult...