Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everybody,
I have an app where I have 3 sheets(it's growing).
On the 1st sheet have 2 buttons and sheet 2 and 3 are hidden (conditional formatting).
What I want to do now is activating sheet 2 when hitting button 1 and sheet 3 when hitting button 2.
But somehow this seem to work only when the sheet are not hidden.
Can anybody advise please?
Susanne
You'll need to unhide the sheet before activating it. I'll assume there is a variable that controls the sheet visibility. So your button should have two actions.
1. Toggle the variable that unhides the sheet.
2. Activate the sheet.
-Rob
You'll need to unhide the sheet before activating it. I'll assume there is a variable that controls the sheet visibility. So your button should have two actions.
1. Toggle the variable that unhides the sheet.
2. Activate the sheet.
-Rob
see attachment