Results 1 to 4 of 4

hyperlink to a hidden sheet

Threaded View

  1. #1
    Registered User
    Join Date
    02-02-2010
    Location
    playa del carmen, mexico
    MS-Off Ver
    ms office 2007
    Posts
    52

    hyperlink to a hidden sheet

    I have a workbook that has many hidden sheets within it (for many reasons). I am looking to create a worksheet with hyperlinks to these sheets, so that I can access them at any point a little easier than I do now.
    So far, I have written the code to scan through each worksheet in the workbook and add those with
    .visible=false
    to the page, and add a hyperlink to that sheet from the name listed.
    These hyperlinks work if the sheet is unhidden, but obviously this defeats the purpose of the entire task.
    I have tried playing around with a few ideas in a
    worksheet_followhyperlink
    event but cannot come up with a solution.
    I am sure it is pretty simple, but would appreciate a little help in finding the right solution.

    Thanks
    Last edited by globalpontoon; 05-10-2011 at 01:12 PM.

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