If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
hyperlinks formula path
Hello, after creating a hyperlink either in a cell or
object, I get this formula path (Screen display) when i point to it. How can I hide it? thank you |
#2
|
|||
|
|||
hyperlinks formula path
Experiment with this (It's a setting in windows, not in Excel):
Right-click on any empty space in *windows desktop* choose Properties Select Appearance tab* click "Item" dropdown menu choose "Tooltip" Choose and apply the font color (just to the right of the "Font:" box) to *match* that of the fill color (just to the right of the "Item:" box) The font will then become "invisible" in the hyperlinks in Excel But note that this is also the default setting for comment boxes as well, so you won't be able to see the text inside comment boxes created unless you change the font color for individual comment boxes to that of a "non-matching" color *If in WinXP, click "Advanced" at the Appearance tab (an additional step) -- Rgds Max xl 97 --- Please respond in thread xdemechanik atyahoodotcom ---- wrote in message ... Hello, after creating a hyperlink either in a cell or object, I get this formula path (Screen display) when i point to it. How can I hide it? thank you |
#3
|
|||
|
|||
hyperlinks formula path
Clarification ..
The font will then become "invisible" in the hyperlinks in Excel should read: The font will then become "invisible" in the hyperlinks' tooltip* in Excel *the box which appears with the filepath when you point at the hyperlink -- Rgds Max xl 97 --- Please respond in thread xdemechanik atyahoodotcom ---- |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula copying from one workbook to another... | MarksNWO | General Discussion | 1 | July 13th, 2004 11:39 PM |
Alternative formula to HLookup | Bernie Deitrick | Worksheet Functions | 0 | March 26th, 2004 12:53 PM |
&[tab] Usage Twist | Jody | Worksheet Functions | 4 | January 10th, 2004 06:21 PM |
Sheet Names | Joseph M. Yonek | Worksheet Functions | 6 | January 3rd, 2004 02:15 AM |