Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping screen tips from displaying for Excel hyperlinks
I'm using Excel 2000.
On a spreadsheet that I'm working on, I've inserted a hyperlink into each of a small number of cells. These hyperlinks work fine, but I don't quite like the way the screen tips for the hyperlinks keep popping up (they obscure important surrounding text). Is there any way I can stop screen tips from being displayed for Excel hyperlinks? Thanks in advance, Sarah. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping screen tips from displaying for Excel hyperlinks
I don't know a way to do this.
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping screen tips from displaying for Excel hyperlinks
Hi Sarah
In the Insert Hyperlink dialog, far up, there's a field "Text to be displayed" and to its right a button "Screen tips" (? I have a translated version here). Click that and enter a single space or something very short. The popup will now show that instead. Not gone, but considerably smaller. I can write a macro to do this on multiple cells if you have too many to do it manually. -- HTH. Best wishes Harald Followup to newsgroup only please "Sarah" skrev i melding ... I'm using Excel 2000. On a spreadsheet that I'm working on, I've inserted a hyperlink into each of a small number of cells. These hyperlinks work fine, but I don't quite like the way the screen tips for the hyperlinks keep popping up (they obscure important surrounding text). Is there any way I can stop screen tips from being displayed for Excel hyperlinks? Thanks in advance, Sarah. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping screen tips from displaying for Excel hyperlinks
Hello, Harald.
Thank you very much for your advice (and good advice at that). I had already tried manually (Insert - Hyperlink - Text to display) and programatically (via the ScreenTip property) setting the screen tip for each hyperlink to "", in the hope that my use of a null string might be interpreted by Excel/VBA as a request to not display a screen tip. Unfortunately, screen tips were still displayed for the hyperlinks, albeit of minimum width (the screen tips looked like blank yellow squares!). I thereafter tried using " " (a single blank) instead of the null string. Once again, screen tips were displayed for the hyperlinks (the screen tips were blank and slightly wider). I had also tried (in desperation) the following, unsuccessfully: (a) Application.ShowToolTips = False (b) Tools - Customize - Options - Clear the check box titled "Show ScreenTips on toolbars". Approaches (a) and (b) failed, not surprisingly, because they related to pop-up tips for toolbars rather than for hyperlinks. Whether or not I ultimately find a solution, I do appreciate your taking the time to assist (as well as your offer of writing a macro for me) .. Thanks! Sarah. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping screen tips from displaying for Excel hyperlinks
Alas, neither do I.
Thanks anyway Edwin, for trying. -----Original Message----- I don't know a way to do this. . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping screen tips from displaying for Excel hyperlinks
Harald ..
In my previous post (addressed to you), I mistakenly claimed that my using the null string for the hyperlink's screen tip resulted in a blank screen tip being displayed. In actual fact, my use of the null string resulted in the screen tip displaying the hyperlink's target address (a large screen tip that obscured quite a lot of the information surrounding the cell that contained the hyperlink!). It was my use of a single blank for the screen tip property, that resulted in a blank screen tip of minimum width. Sorry, for the error in recall. Thanks again, Sarah. -----Original Message----- Hello, Harald. Thank you very much for your advice (and good advice at that). I had already tried manually (Insert - Hyperlink - Text to display) and programatically (via the ScreenTip property) setting the screen tip for each hyperlink to "", in the hope that my use of a null string might be interpreted by Excel/VBA as a request to not display a screen tip. Unfortunately, screen tips were still displayed for the hyperlinks, albeit of minimum width (the screen tips looked like blank yellow squares!). <snip |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suppressing screen tips | Excel Discussion (Misc queries) | |||
Screen Tips | Excel Discussion (Misc queries) | |||
Hyperlink Screen Tips in Excel | Excel Discussion (Misc queries) | |||
Stopping Charts Displaying Zero Results | Charts and Charting in Excel | |||
Excel hyperlinks without screen tips | Excel Discussion (Misc queries) |