Hello,

I have a Main Worksheet that has a list of names corresponding to
worksheets. Currently I have a macro that, if you click on a name, it
unhides and opens the associated worksheet and keeps other worksheets hidden,
when you close the file it hides all sheets except for the main page.

I would like get rid of the list and open excel with an input box where the
user types in the name they want and the corresponding worksheet unhides
opens and leaves the others hidden.

Thanks for your help.