2 Replies Latest reply: Oct 2, 2012 1:35 PM by Graeme Smith RSS

    My macro to enable/disable chart expression often has to be rerun, why?

    Andreas Karlsson

      Hi folks,

      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.

      /Andy