+ Reply to Thread
Results 1 to 7 of 7

Excel Thumbnail

  1. #1
    Registered User
    Join Date
    03-11-2008
    Posts
    27

    Excel Thumbnail

    Dear all,

    I have more than 500 worksheets under the same workbook. The worksheets themselves donít relate on each other (there is no internal links, which sucks). Is there any way I can create a shortcut linking to each worksheet directly like the Thumbnail bar on Acrobat Reader?

    For example, can we arrange the worksheets in Alphabet order under something like the thumbnail? I notice if I right click any worksheet tag and choose view code, a VBA project window will pump out listing all worksheets in order (but that's only for VBA Coding). But it's exactly similar to what I want to be shown on each worksheet. In such case I donít really have to take as long as 2 minutes by only finding the worksheet I need?

    Thanks for all the help!

  2. #2
    Registered User
    Join Date
    03-11-2008
    Posts
    27

    Excel Thumbnail

    Dear all,

    I have more than 500 worksheets under the same workbook. The worksheets themselves donít relate on each other (there is no internal links, which sucks). Is there any way I can create a shortcut linking to each worksheet directly like the Thumbnail bar on Acrobat Reader?

    For example, can we arrange the worksheets in Alphabet order under something like the thumbnail? I notice if I right click any worksheet tag and choose view code, a VBA project window will pump out listing all worksheets in order (but that's only for VBA Coding). But it's exactly similar to what I want to be shown on each worksheet. In such case I donít really have to take as long as 2 minutes by only finding the worksheet I need?

    Thanks for all the help!

  3. #3
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Threads merged.

    HMIExcel08, please don't post the same question in two forums.

  4. #4
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good evening HMIExcel08

    Download and install my add-in via the link below - I believe it may have some tools you could find useful.

    Ultimate > Sheets > Sort Sheets will sort all your sheet tabs into order, alpha, reverse alpha or a custom one.
    Ultimate > Sheets > Worksheet Navigator will put all your worksheets into a toolbar, so you can see them all on screen at once (rather than the limited number you can fit on the bottom of the screen).
    Ultimate > Sheets > Select Sheet from List will install a toolbar on your Excel environment with a drop down box containing all your worksheets. Click on one to go there.
    Ultimate > Sheets > Create Index Sheet will create a new worksheet listing all the other sheets, these can be clickable hyperlinks to take you straight there, or just bog standard text.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  5. #5
    Registered User
    Join Date
    03-11-2008
    Posts
    27

    Re:Ultimate Add-ins

    The forum rule is well noted. Thanks for the remainder.


    Hi dominicb,

    Thank you so much for you link! It's by no mean a powerful add-in feature and I'm sure it will help to save me tremendous time. But I did encounter a troubleshoot using the software.

    I downloaded the "Setup" file and installed it successfully. But when I went to Excel Tool->Add-ins, I could not find the ultimate add-ins option on the list. I clicked "Browse", it leads me directly to Microsoft's Add-Ins folder, where there is no ultimate add-ins either.

    Do you know if the file is hidden somewhere else or I actually did not install it successfully. But I did installed it many times and even tried to reboot my computer.

    Please be advised.

    Thanks!

  6. #6
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Hi HMIExcel08

    The files are not hidden, but from the add-ins dialog you need to click on browse to find them. When you run the install routine the default loacation of the files is C:\Program Files\Ultimate\, so you just need to navigate to the location, click on the file Ultimate Add-In.xla and click OK. The add-in will now appear in your list of addins. Tick the box and click OK to bring it into your Excel environment.

    If you selected somewhere else to put the files, you will need to find out where you put them. You could use the windows search facility (Start > Search) to find where you put them.

    HTH

    DominicB

  7. #7
    Registered User
    Join Date
    03-11-2008
    Posts
    27

    Re:Ultimate Add-ins troubleshoot

    Thank you so much! I have it run fantastically on my Excel.

    Have a great day!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1