Hidin Pivot Tables
 

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

Hidin Pivot Tables
 

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...
--
HTH...

Jim Thomlinson


" wrote:

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