Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables | Excel Discussion (Misc queries) | |||
synchronising pivot tables | Excel Discussion (Misc queries) | |||
Need to create multiple Pivot tables at once | Excel Discussion (Misc queries) | |||
Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) |