Hyper Link Screen Tips

[BrWolv]

Hey All,
Any chance there is an easy way to edit all Hyper link Screen Tips on a Worksheet @ once? I have a sheet with a 100 or so links, that i want a screen tip displayed. Is there an easy way?

thanks

 

[Ralajer]

I think it would have to be a macro solution. The below VBA macro will change all the Screen Tips on Sheet1 to the same values "Press to open hyperlink".

Sub HLSCREENTIP()
    Dim hl As Hyperlink
    Dim rng As Range
    Dim hlTip As String

    '// Refine range if needed
    Set rng = Sheets("Sheet1").UsedRange

        '// To apply to the active sheet
        '// Set rng = ActiveSheet.UsedRange

    '// Tip to replace current tips 
    hlTip = "Press to open hyperlink"
    
    For Each hl In rng.Hyperlinks
        hl.ScreenTip = hlTip
    Next hl
End Sub

 

[BrWolv]

This worked perfectly for me, thank you very much!!!