| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Suppressing screen tips
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Screen Tips | Excel Discussion (Misc queries) | |||
| Hyperlink Screen Tips not cross platform | Excel Discussion (Misc queries) | |||
| Hyperlink Screen Tips in Excel | Excel Discussion (Misc queries) | |||
| suppressing the splash screen | Excel Discussion (Misc queries) | |||
| Excel hyperlinks without screen tips | Excel Discussion (Misc queries) | |||
Threaded Mode
