Hide and unhide tabs using drop-down menu with in excel

Where is drop down menu located? On other tab? Or the same drop-down is located on each of Result tabs?
You've said I've got 4 tabs so I suppose dropdown is on each of them, so (in case if drodown menu is located in A1):

Please Login or Register  to view this content.

code have to be put inside EACH OF 4 RESULT TABS.

Check attached file.

So ONLY into Inputs vba code:

Please Login or Register  to view this content.

check attached file.

Hello Hanz-Germany,

The drop-down menu is on another tab ("Inputs") located

It is difficult to guess what your Workbook set-up looks like.

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.

Thanks a lot, KOKOSEK. The code is exactly what I looked for.
Apologies, I forgot that I have more tabs which should be hidden. Do you know how the code should look like for this case?

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.

For your convenience, I have attached the worksheet.

Thanks a lot again for your help. Highly appreciated.

Oh Hanz...

Please Login or Register  to view this content.

Thanks a lot KOKOSEK.

Firstly, I hoped that I can adjust the rest on my own, but I just don't know how to adapt this code.

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

All my apologies for the inconveniences, I am very sorry!!!! I thought I begin simply and do the rest on my own, but my excel vba knowledge is far too basic for this adaptation.

Would you mind helping again with the code? I would be most grateful.

Thanks a lot.........

No problem. As I did not know on which sheet you want to put your dropdown menu, I've put it on cover (in attached file).
It shows all existed tabs but visibility of Results / ICER depends on choosen scenario number.

In attached file code in cover sheet is:

Please Login or Register  to view this content.

Cross-post here: https://www.mrexcel.com/board/thread...excel.1116525/
Please read https://www.excelforum.com/forum-rul...rum-rules.html (point 3).