Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making only selected PivotFields visible via macro
Hi there,
I have a pivot table that has many PivotField values. I want to allow users to be able to hit a button that makes only selected PivotFields visible (rather than the users having to deal with the actual pivot themselves). Iniitally I guess I have to set all PivotFields.visible value to false & then select the ones I want to show. Problem is, the underlying raw data & hence the pivot get updated every day, so the PivotFields *may* increase in number with different values. I therefore have to account for all PivotFields dynamically each time the macro is run before deciding which ones to show. Does this make sense & does anyone know of a way of doing this? Any input appreciated Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making selected cells more visible | Excel Discussion (Misc queries) | |||
Making visible a picture | Excel Discussion (Misc queries) | |||
making only specified columns visible | Excel Discussion (Misc queries) | |||
Macro for making worksheets visible. | Excel Programming | |||
Help: Macro to to sum across selected visible worksheets | Excel Programming |