Announcement

Collapse
No announcement yet.

link to hidden sheets

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • link to hidden sheets



    I am wondering how to link from one cell to a cell in a hidden sheet in the same excel file.

  • #2
    Re: link to hidden sheets

    Links to hidden sheets work the same as any other sheet. It would probably be easier to unhide the sheet, create the links, then hide it again. But you can also just type the references to the hidden sheet. For example:
    =SUM(HiddenSheetName!A2:A300)
    Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us will be ignored.

    Comment


    • #3
      Re: link to hidden sheets

      when I create the link then hide the sheet it, the link does not do anything. And i'm not trying to use the data for a formula i'm just trying to go to that cell when it is on the sheet that is hidden.

      Comment


      • #4
        Re: link to hidden sheets

        By link, do you mean hyperlink?
        Boo!

        Comment


        • #5
          Re: link to hidden sheets

          yes I do mean hyperlink.

          Comment


          • #6


            Re: link to hidden sheets

            Well the only way I can think of to get your hyperlink to work would be to use code with the FollowHyperlink worksheet event to unhide the sheet.
            Code:
            Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
            Dim strRng
                strRng = Target.SubAddress
                Sheets(Left(strRng, InStr(strRng, "!") - 1)).Visible = True
            End Sub
            Boo!

            Comment

            Working...
            X