Hide all worksheet except 5 input sheets and a 6th sheet selected in a drop down list

I have been trying to solve this problem from previous threads and can not seem to get it right

I have and excel book with 53 sheets.

I am looking to keep 5 input tabs permanently unhidden:
“Input 1”, “Input 2”, “Input 3”, “Input 4” and “Input 5”

I also want to unhide one of the other forty-eight hidden tabs depending on the selection made from the drop down list in “'Input 1'!C52”

The Names in the drop down list are the same as those on the forty-eight hidden sheets

I am at my wits end and would really appreciate any help,

thanks in advance

Please Login or Register  to view this content.

Gents,

Thank you so much for you quick responses you have just made my day that much easier.

Richard, I couldn't get your code to work but RichTea 88 yours worked perfectly first time,

Thank you again,

Hey Richard,

I just gave your code a try and it works fine the first time I try it, but when I change the input in C52 and try it a second time I get an error and it hides all the sheets except Input 5...

I can't work out why. The error occurs on this line

Please Login or Register  to view this content.

and when I hover it says
ws.Visible = xlSheetHidden = False

In fact the error only occurs if I've selected an unnamed sheet, for example 'Sheet8'.

Sorry, what I was meaning was that the sheet does exist, but its just the default name, "Sheet8". Though the error does occur if there is no sheet.

But an Error Handler would probably work for that as well. I was just curious as to what it could be because I can't see why your code wouldn't work.

Haha,

Right I just tried it again and the error doesn't occur if 'Sheet8' is visible in the first place.

But if you'd already searched for another sheet 'Check' for example, then Sheet8 is hidden. Now when you try to search for sheet 8, that's when the error occurs. (I've attached the workbook I was testing with)

:P Don't think I've seen a solved thread go on this long

I'm exactly the same, couldn't have let it lie!

Let it never be said that too many ***** spoil the broth (also a Richard)