Apr
26
Deselecting Button on a Different Sheet
Video tutorial https://www.youtube.com/watch?v=MyGZPuI0oXo
Following the previous post, my colleague said the trick doesn't work for him, because his buttons are placed in different sheets. BTW, a button here means any data mark where action is initiated via selecting. Note that when the buttons are on different sheets, a button may stay selected but won't be dimmed.
Then I devised a new scheme where buttons are on 2 different sheets. When selecting one, it deselects the button on the other sheet. There could be more than one buttons on the other sheet.
It takes the following key steps:
- Create a parameter with two values (more values if more sheets for swapping), each value corresponding to the Sheet dimension of each button.
Following the previous post, my colleague said the trick doesn't work for him, because his buttons are placed in different sheets. BTW, a button here means any data mark where action is initiated via selecting. Note that when the buttons are on different sheets, a button may stay selected but won't be dimmed.
Then I devised a new scheme where buttons are on 2 different sheets. When selecting one, it deselects the button on the other sheet. There could be more than one buttons on the other sheet.
It takes the following key steps:
- Create a parameter with two values (more values if more sheets for swapping), each value corresponding to the Sheet dimension of each button.