+ Reply to Thread
Results 1 to 3 of 3

Create table of contents sheet

  1. #1
    Registered User
    Join Date
    01-14-2006
    Location
    Calgary,Alberta
    Posts
    11

    Create table of contents sheet

    Hi,
    I am looking for a code that will create a sheet and then add hyperlinks to the other sheets in the workbook,

    Thanks

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475
    Check out this cool code, from nick hodge
    http://www.nickhodge.co.uk/files/vba...sheetIndex.xls

    Hit Alt+F8 to find the macro

    Here is the site with the example workbook as well as other examples
    http://www.nickhodge.co.uk/vba/codeexamples.htm
    Last edited by davesexcel; 05-25-2008 at 07:51 AM.

  3. #3
    Registered User
    Join Date
    01-14-2006
    Location
    Calgary,Alberta
    Posts
    11
    Thank you,
    And thanks for that link.

+ 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