cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Analysis for Office - How do I hide scaling factors with VBA

former_member673155
Discoverer
0 Kudos
512

I need to ensure

Analysis tab > Display group > Measures dropdown > Show Scaling Factors

is unticked before I run my macro. I need to do this because occasionally the scaling factors row is automatically hidden (as there is no scaled data), so I'd like to account for this so I don't miss data in these cases.

Looking through the documentation I can't find how to disable this property. Any ideas?

Accepted Solutions (0)

Answers (0)