prevent hyperlinked area being highlighted

  • I have a number of range names that I hyperlink to but when you get to the area the highlight makes the colours look a bit of a mess.

    Not a particularly important point I guess, just irritating. Is there a way to avoid the highlight while maintaining the hyperlink.

    I can hyperlink to a smaller region but then there is no guarantee that all of the page I am linking to will be displayed (depends upon the last user scroll on that page).

  • Hi Justin

    About the only thing I can think of is to use a Macro to take the user to a named range and then have the macro select on the top left cell of it, e.g

    1. Sub GoThere()
    2. Application.Goto Range("MyRange"), True
    3. Range("MyRange").Cells(1, 1).Select
    4. End Sub
  • Re: prevent hyperlinked area being highlighted

    I reckon Dave Hawley posted this reply to a similar query regarding charts. I've removed the line of code that activates the chart. It works well because you just select one cell (the top left one of your range), but always approach it from the bottom right, so the correct range is always visible. It can be adapted for multiple hyperlinks quite easily.

    'Here's another workaround. Hyperlink to any sheet cell IV65536. Then use this code in that Sheet Module'
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Address = "$IV$65536" Then
    Application.Goto Range("A1")
    End If
    End Sub