Hide and unhide tabs using drop-down menu in excel

[Hans_Germany]

Hi all,

I attached the original worksheet where some tabs should be visible all the time, and some of the tabs "results" and "icer" should only be visible depending on the selection in the drop-down list on the "efficacy inputs" sheet.

The drop-down list contains 4 items (Scenario 1, Scenario 2, Scenario 3, Scenario 4).

Following sheets should be visible all the time:

Cover

Instructions

Efficacy inputs

Utility & cost input

Therapy cost inputs

Calculator Fosta

Calculator BSC

B.3.2

B.3.4

B.3.6

B.3.7

Appenix J

QALY

costs

resource use

1-way sensitivity

Depending on the drop-down list in cell B2 on the "efficacy inputs" sheet, certain tabs of "Results" and "ICER" should be hidden:

When "Scenario 1" is selected, only the tabs "Results 1" and "ICER 1" should be visible and the other tabs (Results 2, Results 3, Results 4, ICER 2, ICER 3, ICER 4) should be hidden.
When "Scenario 2" is selected, only the tabs "Results 2" and "ICER 2" should be visible and the other tabs (Results 1, Results 3, Results 4, ICER 1, ICER 3, ICER 4) should be hidden.
When "Scenario 3" is selected, only the tabs "Results 3" and "ICER 3" should be visible and the other tabs (Results 1, Results 2, Results 4, ICER 1, ICER 2, ICER 4) should be hidden.
When "Scenario 4" is selected, only the tabs "Results 4" and "ICER 4" should be visible and the other tabs (Results 1, Results 2, Results 3, ICER 1, ICER 2, ICER 3) should be hidden.

Does anybody know what the appropriate code for that is?

Thanks a lot in advance for your help. I highly appreciate it.

 

[KOKOSEK]

Cross-port here: Hide and unhide tabs using drop-down menu with in excel
Read forum rules.

 

[Hans_Germany]

Issue is solved. THANKS A LOT!!!

 

[KOKOSEK]

I know. You welcome.