Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Macro - Hyperlink Cell A1 in all but one worksheets to Cell

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    359
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How do I Hyperlink the cell A1 in all worksheets but one (actually need to exclude more than one, although code for excluding one will probably be easy enough to change) to cell A1 in excluded worksheet (named SUMMARY?

    I want the included worksheeets to have the cell A1 to hyperlink back to cell A1 in the worksheet called SUMMARY.

    Is there a macro that I can create to help choose which worksheet to view? Maybe a combo box on each page? BUT I need those combo boxes to appear automatically on each worksheet and be popoulated automatically since this workbook is update continually.

    Any ideas?

  2. #2
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Cosmos75,

    The following macro will hyperlink cell A1 on all worksheets to A1 on the worksheet named "Summary".

    Sub HyperlinkSheets()
    'Hyperlinks cell A1 on all worksheets to A1 on worksheet Summary
    '(except for Summary itself, of course)
    Dim Sh As Object
    For Each Sh In Sheets
    If Sh.Name <> "Summary" Then
    Sh.Hyperlinks.Add Anchor:=Sh.[a1], Address:="", _
    SubAddress:="Summary!A1", _
    TextToDisplay:="Go to Summary"
    End If
    Next Sh
    End Sub

    Keep Excelling.

    Damon

    VBAexpert Excel Consulting
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    359
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Damon Ostrander,

    Thanks, works great! Saved me a lot of time from having to do that manually!

    Know if the second part of my post is possible?

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
  •