+ Reply to Thread
Results 1 to 2 of 2

Create list of hyperlinks to all sheets

  1. #1
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    155

    Create list of hyperlinks to all sheets

    Attached is a workbook where I took VBA code created by someone to list all the worksheets in order and create hyperlinks. The code runs very slow and does not work when I click on a link. Any ideas?
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,696

    Re: Create list of hyperlinks to all sheets

    This revision fixes the problem with the links, but the original runs very fast for me, fraction of a second.

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. create non-repeated worksheets (copy of template) with hyperlinks from main list
    By helpwanted222 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-19-2015, 05:48 AM
  2. Vba to create hyperlinks for multiple sheets on one page
    By iastshane in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2015, 09:45 AM
  3. Macro to create hyperlinks between sheets
    By Ashok Dsouza in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2012, 10:18 AM
  4. Creating hyperlinks from Data Validation list to other sheets within xls
    By dpcp in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-29-2012, 12:39 PM
  5. Create List and Hyperlinks Based Upon Cell Contents
    By nofzinger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2010, 03:44 PM
  6. [SOLVED] Use VBA in Excel to Open Word Doc and Create a list of Hyperlinks
    By Raul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2006, 01:25 PM
  7. [SOLVED] how to create multiple hyperlinks within a dropdown list
    By dan in forum Excel General
    Replies: 0
    Last Post: 06-28-2005, 09:05 PM

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