Results 1 to 5 of 5

Thread: Hyperlink to hidden worksheets in excel 2010
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Feb 2016
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Hyperlink to hidden worksheets in excel 2010

    I have not ever worked in excel, until 2 months ago. I would like to hyperlink into hidden worksheets.

    I have a master list with hyperlinks - that don't work if the worksheets are hidden. I listen to podcast 1729, but it did not work?

    Private Sub Worksheet_FollowingHyperlink(ByVal Target As Hyperlink)
    LinkTo = Target.SubAddress
    Wherebang = InStr(1, LinkTo, !)
    If WhereBang > 0 Then
    MySheet = Left (LinkTo, WhereBang 1)
    Worksheets (MySheet).Visible = True
    Worksheets (MySheet).Select
    MyAddr = Mid (LinkTo, WhereBang +1)
    Worksheets (MySheet). Range (MyAddr).Select
    End If

    End Sub

    Can someone help me!!! Please


  2. #2
    Board Regular
    Join Date
    Feb 2009
    Location
    Massachusetts, USA
    Posts
    1,977
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Hyperlink to hidden worksheets in excel 2010

    Hi Sean,

    Welcome to the board.

    Maybe something like the following sample:

    Code:
    Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    
    Dim vSplit As Variant
    
    vSplit = Split(Target.SubAddress, "!")
    
    If Worksheets(vSplit(0)).Visible = False Then
    
        Worksheets(vSplit(0)).Visible = True
        Worksheets(vSplit(0)).Activate
        ActiveSheet.Range(vSplit(1)).Activate
    
    End If
    
    End Sub
    Murphy's Fifth Law: If anything absolutely can NOT go wrong, it will anyway.

  3. #3
    New Member
    Join Date
    Feb 2016
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Hyperlink to hidden worksheets in excel 2010

    Thank you!!!! I'll give it a try and let you know.

  4. #4
    New Member
    Join Date
    Feb 2016
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Hyperlink to hidden worksheets in excel 2010

    Thank you again, but no luck.

  5. #5
    New Member
    Join Date
    Feb 2016
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Hyperlink to hidden worksheets in excel 2010

    FYI - i am working in 2010 excel

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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