Add Sheets to Toolbar

[SandMan]

I'm trying to develop a macro that will enable a user to select a sheet name from a listbox or combobox and then take the user to that sheet. I can create the list and populate the names but I can't get it to take me to the sheet once I select the name. Either that or add all the sheets to a custom menu in the toolbar. Once again, I can create the list in the tool bar, but I can't get the sheet to pop up after I select the sheet name. Please Help!!

 

[royUK]

Hi
You can hyperlink to each page in the workbook. Create your list on a Menu Page and use <Insert>Hyperlink>Place in this Document.
You can create a button with a return to menu hyperlink and copy it to each page
Or more easily download the asap addin from http://www.asap-utilities.com and use his utility from the Sheets Menu.this will create a hyper-linked list to all pages in the workbook

 

[SandMan]

I'm using an "Index page" right now and I'm trying to get away from it. With the number of sheets that I'm using right now (over 90), the index page is getting to be a little much. I am looking for something simple and small (but it's turning out to be a little more complicated then I thought!)

 

[Jim North]

Are you aware that if you right click on the sheet movement control bar (down in the lower left hand corner... to the left of the tabs... looks like VCR buttons) it gives you a list of worksheets?

 

[SandMan]

I knew about the sheet list from right-clicking the arrows in the bottom left and at one point even found the VB code to make the list pop-up automatically when the book was open. But the people that use the workbook didn't know why that kept popping up and would close it every time. I'm trying to make something that if someone doesn't know anything about excel, they would still know how to navigate through the workbook. The index sheet has been working good, its just getting to be a bit much, and I'm always adding new sheets everytime we get a new customer.