Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Select worksheets from a pull-down menu? (2002)

    Thanks in advance for the help on this.

    I am not sure if this can be done, but I would like to add a pull-down menu from which I can select any worksheet within the active workbook. I know that if you right-click the tab navigation arrows on the bottom left of the window you can do this from the pop-up window, but it only lists the first 15 sheets. Most of my workbooks have 20-25 worksheets. Alternatively, can the number of worksheets in this pop-up window be modified?

    Thanks again.
    Terry
    Seattle, WA

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Select worksheets from a pull-down menu? (2002)

    Click on the "More Sheets" on the bottom and you get a dialog box that you can scroll.
    If you have a lot of worksheets, what I have found useful, is to hide the sheet names and create an "Index" page with hyperlinks to each sheet. That way you could have multiple references (alphabetized) to the sheets themselves. I have between 3 - 8 references to each of the sheets (mfg codes, mfg names, customer codes, customer names, etc) it makes finding things easier.

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Select worksheets from a pull-down menu? (2002)

    This is a useful thread on Sheet Selection It may give you some ideas on what to do.


    HTH

    Peter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •