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.

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.

Thank you. This worked very well.

"Jim Rech" wrote:

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.