Input box opens hidden worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Rose,
Possibly...

Format | Sheet | Unhide

Jim Cone
San Francisco, USA


"Rose" <[email protected]>
wrote in message
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check Box Question 1
Open Specific Worksheet Using Button Form Control in Excel 0
Make a check box run a macro 5
Protect each worksheet individually 4
Replace password with *** in input box, xlVeryHidden 11
preventing access to hidden worksheets 3
Can't find a hidden worksheet that appears in the name manager 4
Hide worksheet when moving back to another sheet 2

Back
Top