Results 1 to 4 of 4
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Workbook Navigation (XP)

    Hi All,

    I have a couple of large workbooks (don't we all) and I'm getting sick of alt page up and alt page down (not to even mention the silly mouse). SOOOOO, anyone got any hints on useful workbook navigation - macro or otherwise would be useful.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  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: Workbook Navigation (XP)

    For a LARGE number of sheets, I have found that an INDEX sheet which has hyperlinks to each of the sheets works relatively well.

    I had an (inherited) workbook with over 300 sheets that I KNEW how to fix but could not find the time to invest in revamp so I lived with it and made it easier to manipulate. Each sheet had from 2 - 6 crossreferences on the index sheet. Thes hyperlinks were alphabetized by code, Notebook#, product name, etc so from the index you could hyperlink to any sheet. Each sheet had a button to return to the index page.

    Since the size of the index sheets can get large, I also grouped them and kept each group to be just 1 screen (no scrolling) and had buttons to go to various letters or other subgrouped "screen" on the index sheet.

    Then I hid all the tabs so people did NOT even have to use the tabs at all.

    Steve

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Workbook Navigation (XP)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Tim

    Since you know what sections, or what worksheets you visit the most, you can write some VBA code to take you there.

    Try something like

    Sub TakeMeThereCountryRoad()
    Application.Goto Reference:="Sheet2!" & Range("B12").Address(ReferenceStyle:=xlR1C1)
    End Sub

    If you don't want to use code, try the F5 Goto with a bunch of Named Ranges. But again, this will take time to design the named ranges.

    HTH

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  4. #4
    Star Lounger
    Join Date
    Mar 2003
    Location
    Sydney, New South Wales, Australia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workbook Navigation (XP)

    Try Navigator Utilities (at http://www.robbo.com.au). It has a Sheet Navigator which allows you to easily move between sheets, as well as showing hidden and protected sheets, and lots of other features. Also helps you to navigate around links and named ranges.

    regards

Posting Permissions

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