Activate hidden sheets with button

[Anonymous]

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

[rwunderlich · Accepted solution]

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]

see attachment