(De)activate hidden worksheet

[Anonymous]

Hi all,

I would like to hide a worksheet and open it with a action button (activate worksheet).

My problem is that if i hide the worksheet with relation = 0, it can't be activated.

Is there a possibility to show and to hide a worksheed by a action button?

If you need further infornation just tell me!

Thank you for helping,

Robert

[julian_ortiz · Accepted solution]

Hi Robert.

I atached a qvw. Hope this helps.

I Created one variable to hide/show a worksheet with action.

Regards

Julian

[antose]

Tips! If you hide anything by mistake or with a wrong If-statement you can always show it again with Ctrl+Shift+S

[Anonymous]

Really great!

Thank you very much.

[antose]

Hi again!

I know you already have received a correct solution but have one more tips.

I'm not a big fan of big buttons so what you can do is to add a listbox and then have show condition on the sheet.

[Anonymous]

Thank you for this tip!

I don't need it for this problem, but it will help later!