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

    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?


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

  2. #2
    Join Date
    Jun 2011
    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
    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.


Posting Permissions

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