You could run this macro:

Sub ReplaceHyperlinkScreenTips()
Dim HL As Hyperlink
For Each HL In ActiveSheet.Hyperlinks
HL.ScreenTip = "Click to follow"
Next
End Sub


--
Jim
"Wiz1214" wrote in message
...
|I am working in Excel 2002 (10.6501.6735) SP3.
| I need to suppress the screen tips which pop up automatically on
mouse-over
| of a hyperlink in a spreadsheet. I can do this individually, but I am
| working with a reference list of documents which hyperlinks the user to
the
| individual document to view online. With more than 300 links in each
list, I
| would really like to find a global suppression instead of individually
| entering a blank for the screen tip. The screen tip which pops up is the
URL
| for the hyperlink, which by necessity must include the user name and
password
| to connect to the secured site where the documents reside. I do not want
| this displayed to the end user, so I need to supress the screen tips.
| The instructions in the help screen tell me to modify
| TOOLS/CUSTOMIZE/OPTIONS/Other - Show shortcut keys in Screen Tips, but
that
| option is not available on my Options screen. It stops at Show screentips
on
| toolbars, (this option has no effect on this issue).
| I welcome any suggestions to help me avoid individually modifying 300+
| hyperlinks per list. Thank you.