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

    Sub GoThere()
        Application.Goto Range("MyRange"), True
        Range("MyRange").Cells(1, 1).Select
    End Sub
  • yep that will do it


    I have written all of the hyperlinks in the cells so I will do this when I have a bit of time to start converting to more VBA code.

    I am starting to enjoy it. Must be a catching bug...

  • 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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!