My macro to enable/disable chart expression often has to be rerun, why?
I attach a small trivial qvw.
I have done a button-macro-variables solution to enable disable expressions in a pivot chart.
It works as excpected. BUT if I toggle more than one variable, suppose alla expressions are shown and I want to hide all those on which I have an option (that is all expressiones exept no 0), then most of the times 2 of them are hidden in the first push on the button and then two more pushes hides the other 2 expressions.
I guess I have done some bad coding but since I'm not used to VB at all I just cannot find it myself but asks for some clever macro-coder to tell me what is wrong.