Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

check status of dim enable conditional in a macro

Hi,

we have a pivot table.

The dimensions have enable conditional expressions to be shown or not, based on the condition.

Works fine.

Now we need to find out in a macro,

if a condition is true or even better, if the dimension is shown.

Is there an easy way to do that?

If not I would have to read the EnableCondition.Expression and try to analyze it.

We need to do that,

because we want to check cell values, but only for the dimensions,

which are shown (condition = true) in the pivot table.

Roland

1 Reply
Anonymous
Not applicable
Author

Hi,

solved... we went the hard way, by analyzing the condition.

Roand