Unhide or hide sheets based on drop down list value - need help combining these two macros

Welcome to the Forum!

First, do you need help writing the code for Macro 1? You have shown code that doesn't actually work because the Range values just look like descriptions of what you want to do, rather than actual range values. For example, I would suggest this:

Please Login or Register  to view this content.

As far as the rest, it is not at all clear what you want to happen when the workbook is opened, what it means when you say "selected values will stay in place", whether you need some kind of help with your second macro, or what you mean by combining the two macros.

The first post said that the sheet selected from the dropdown becomes visible, here you say when the file opens you want them to remain hidden. Can you clarify which one you need? My code makes the selected sheets visible.

I would have one Sub that sets the visibility of sheets as shown in the code I provided above. Then the same code would be called by Worksheet_Change and Workbook_Open. Workbook_BeforeClose would hide all sheets.

This goes into a new Module:

Please Login or Register  to view this content.

This goes into the Worksheet module:

Please Login or Register  to view this content.

This goes into the Workbook module:

Please Login or Register  to view this content.