Unhide Hidden Sheet when search button is used

Hi all i have created a search button that searches my Wb for a sheet name.
The only thing is i need to keep all my sheets hidden that im searching for due to data protection.
I have created the button and it cannot find the hidden sheets.

If possible could somebody please help me format the button to Search all hidden and unhidden sheets for the name entered in the search, and if it does find said sheet to unhide it for me and show me the sheet required.

Here is the code that i currently have and does work for all visible sheets:

Please Login or Register  to view this content.

Any help would be great thanks

Chris

See if this helps

Please Login or Register  to view this content.

Thanks