I am trying to implement a "conditional show" for container objects.
The condition I am using is:
=Divison='ABC' or =Division='DEF'.
So dependant on the division selected by the user only the corresponding container objects should be shown.
I am using the same condition for chart objects and it works perfectly, but it doesn't work properly for CT objects, as I am loosing them either completely or sometimes, they just appear independant of the division selected.
When I go to sheet properties->objects, I can still find them in the list, but I can't get the back unless I remove the objects within a container. Once I do that, I see the empty container on the sheet and have to add the objects again.
Did anybody face similar issues or has an idea, what is going wrong?
Thanks for your help!