Hide/Unhide Sheets based on drop down list

Guys,
I have tried a couple codes from Google for this but without success.
Is there any one who can help me with this.

Sheet1--->A1 is drop down list with:
All
FIN
RET
Oth

Now, I would like to create VBA code and when I select "All" to unhide ALL SHEETS then.
If I select FIN, I would like to see "FIN" and to hide RET and Oth.
Else, if I select RET, Would like to hide FIN and Oth and so on.

Ideas?

Thank you in advance.

Is there any way to get something that I don't need to run macro.
Just on selected "case" from drop down list to hide/unhide specific sheets.
I would like to avoid "button" for macro.
Thanks!

Sure, no problem.

I am gonna make an example and put it here because the code above doesn't work for me.

Here it is.
As you can see in VBA I have the code for hiding rows which is connected on cell C4.
Now I would like to put your code for hiding sheets based on criteria in C5.
e.g. if I selected in C5 = "All Divisions" then show me all sheets. If it's selected "Financial" hide all except "Region FIN", "Control Tab", "Calculations" and "Actuals".
Or if I select "Retail" ---> hide all except "Region RET", "Control Tab", "Calculations" and "Actuals"

I hope so this is an appropriate example for you.
Thank you very much for help.

Nope, still doesn't work. Only works fine if I select "All Divisions". When I select "Financial" it hides and "Region FIN" but it should be visible.
Also if I select case "Financial" and then "Retail" nothing happens.
I can't figure out on which principle this code works, I mean, how it's know which Sheets to hide?
What if I add some new sheets?

Originally Posted by toci

Sheet1--->A1 is drop down list with:
All
FIN
RET
Oth

Now, I would like to create VBA code and when I select "All" to unhide ALL SHEETS then.
If I select FIN, I would like to see "FIN" and to hide RET and Oth.
Else, if I select RET, Would like to hide FIN and Oth and so on.

So again... I don't think you really explained yourself very well at all. The code I gave you looks for the value in cell C5 and hides all other sheets WITH THE EXCEPTION of the one with the name matching the value in C5, and the "Control Tab". So either change the names in your dropdown to FIN, RET, etc. OR change the names of your sheets to "Financial", "Retail", etc.

OTHERWISE, if you must have the two be different I suggest using a Vlookup (in either a column you hide or in a locked cell with white text) on your dropdown and having a list of the dropdown options and their corresponding sheets on a separate sheet/hidden columns. If you do this you will have to modify the code I gave you to point to the Vlookup result and NOT c5 where it currently pulling the value from.

Again, the code matches the Value of your dropdown and hides all sheets without the matching name, so if you are using values in your drop down that differ from your sheet names it will not work.