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:
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.
- Create one filter per sheet for sheet selection
- Set up deselect action
- Set up parameter action for sheet swap
See the previous article for creating both parameters and sheet select filters.
But the deselect action and parameter action are a bit different from the previous case where buttons are on the same sheet. A button will need to stay selected until another button is selected.
Set up deselect action
- Create a calculated field True whose content is True as well in both Button sheets
- Create a filter action for each sheet as follows
- Make sure to use True field to target the same True field in the other Button sheet(s).
- We need to create as many actions as buttons.
Set up Parameter Action for sheet swap
- Need to set up as many actions as buttons
That's all. You can download the demo workbook here.
.png)
Add a comment