Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Activate hidden sheets with button

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

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

maxgro
MVP
MVP

see attachment