Unhide Sheets using "Case Is"

Hello,

I have an Excel book with various sheets. On the main page the user should be able to Unhide a sheet based on a select option. I don't have any Vba coding skills, is there a source where I can copy and paste the code?

Thanks

If your sheet names are in the range B3:B5 (change this as needed), when you double click the name of the sheet, it will unhide it, hide all other sheets, and then activate the sheet for you. To add this code, right click the sheet that will have the contents and choose View Code. Paste this in there:

Please Login or Register  to view this content.

Thanks thomglea for the reply.
Unfortunately the code does not work for me. The code seems to be based on Cells, I am looking to unhide the sheet based on the name of: Sheet 1 User selects "Overview", Overview sheet unhides, remaining sheets remain hidden.

Cheers