#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How to hide a pop up

Hi

I am working on a worksheet in Excel with lots of hyperlinks. When I place
the cursor over a cell with a hyperlink a yellow pop up appear with a
description of the hyperlink ("file:///C:..."). Is there anyway to turn off
this pop up? I really need help on this.

Carsten
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 663
Default How to hide a pop up

Hi,

You cannot ingore the Hyperlink tip. But you can customize the tip
information you require to show, when the user places the cursor on the link.

Do the following:

1. Right-click on the hyperlink, and select Edit Hyper link.
The Edit Hyperlink dialog box is displayed.
2. By default the hyperlink displays the following tip information:
a. Workbook name
b. Sheet tab name
c. Cell refernce
d. Message - Click once to follow, Click and hold to select this cell
3. On the right of Text to diaplay text box, click rhe Screen Tip button.
The Set Hyperlink ScreenTip dialog box is displayed.
4. Enter a text in the ScreenTip Text.
Note: You can enter a customized text in the ScreenTip Text box. if you
leave the ScreenTip Text box blank, then the step 2 will be displayed.
5. Click Ok to set the customized hyperlink tip or click cancel to return to
the Edit Hyperlink dialog.
6. Click Ok in the Edit Hyperlink dialog box to return to the Worksheet.

Challa Prabhu

Important: Hyperlink tip cannot be blank.

Challa Prabhu

"Cabri" wrote:

Hi

I am working on a worksheet in Excel with lots of hyperlinks. When I place
the cursor over a cell with a hyperlink a yellow pop up appear with a
description of the hyperlink ("file:///C:..."). Is there anyway to turn off
this pop up? I really need help on this.

Carsten

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How to hide a pop up

Thanks

This is a lot better. It would still be great to be able to ignore the
Hyperlink tip, but I can sure live with this.

Thank you very much.

Carsten

"challa prabhu" wrote:

Hi,

You cannot ingore the Hyperlink tip. But you can customize the tip
information you require to show, when the user places the cursor on the link.

Do the following:

1. Right-click on the hyperlink, and select Edit Hyper link.
The Edit Hyperlink dialog box is displayed.
2. By default the hyperlink displays the following tip information:
a. Workbook name
b. Sheet tab name
c. Cell refernce
d. Message - Click once to follow, Click and hold to select this cell
3. On the right of Text to diaplay text box, click rhe Screen Tip button.
The Set Hyperlink ScreenTip dialog box is displayed.
4. Enter a text in the ScreenTip Text.
Note: You can enter a customized text in the ScreenTip Text box. if you
leave the ScreenTip Text box blank, then the step 2 will be displayed.
5. Click Ok to set the customized hyperlink tip or click cancel to return to
the Edit Hyperlink dialog.
6. Click Ok in the Edit Hyperlink dialog box to return to the Worksheet.

Challa Prabhu

Important: Hyperlink tip cannot be blank.

Challa Prabhu

"Cabri" wrote:

Hi

I am working on a worksheet in Excel with lots of hyperlinks. When I place
the cursor over a cell with a hyperlink a yellow pop up appear with a
description of the hyperlink ("file:///C:..."). Is there anyway to turn off
this pop up? I really need help on this.

Carsten

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hide help with excel New Users to Excel 2 March 9th 07 12:27 PM
Hide Unhide Hide again DTTODGG New Users to Excel 1 February 15th 06 03:22 PM
hide "#VALUE!" Brian Excel Worksheet Functions 10 June 8th 05 05:51 PM
How do I hide a worksheet in Excel and use a password to un-hide . Dchung Excel Discussion (Misc queries) 3 December 2nd 04 06:24 AM
how to hide #N/A's? Todd Excel Worksheet Functions 11 November 8th 04 04:34 PM


All times are GMT +1. The time now is 04:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"