Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Location
    Huddersfield, UK
    Posts
    154

    Wink Unanswered: Hyperlinks and Hidden Sheets

    Hi Y'all

    Just wondered if it is possible in excel to create on a sheet (call it say cover sheet) with links to sheets that I intend to hide as these sheets provide background data thats not neccessarily important, but on the cover sheet still have access to these via a hyperlink or such?

    Thanks

    dan
    sometimes simple is best.... and i'm just a simple fellow.

  2. #2
    Join Date
    Jun 2011
    Posts
    10
    hi danlindley

    It is easy enough to create a hyperlink to another sheet..

    Insert > Hyperlink > "Place in this document"

    You can then change the targeted place to a sheet name or defined range. Only problem is that this doesn't work if the sheet you are referring to is hidden.

    You could use a macros maybe attached to a button or a cell to unhide a sheet and then to select a specific area on that sheet.. something like the below should work....

    Sub Macro1()
    '
    ' Macro1 Macro
    '
    Sheets("Sheet2").Visible = True
    Sheets("Sheet2").Select
    Range("A1").Select
    End Sub


    You would then need another button or macro to close the sheet and return to the original page. If you are unsure of macros there is a record button which is sometimes easier, it will record your actions and you can then adapt it to what you need.

    Cheers.

Posting Permissions

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