If friendly_name is omitted, the cell displays the link_location as the jump text.ДЇriendly_name can be a value, a text string, a name, or a cell that contains the jump text or value. Friendly_name is displayed in blue and is underlined. If the jump specified in link_location does not exist or can't be navigated, an error appears when you click the cell.ДЇriendly_name is the jump text or numeric value that is displayed in the cell. Link_location can be a text string enclosed in quotation marks or a cell that contains the link as a text string.

The path can be to a file stored on a hard disk drive, or the path can be a universal naming convention (UNC) path on a server (in Microsoft Excel for Windows) or a Uniform Resource Locator (URL) path on the Internet or an intranet. Link_location can refer to a place in a document - such as a specific cell or named range in an Excel worksheet or workbook, or to a bookmark in a Microsoft Word document. Link_location is the path and file name to the document to be opened as text. When you click the cell that contains the HYPERLINK function, Excel opens the file that is stored at the location of the link. You can use the HYPERLINK function to create a link that opens a document that is stored on a network server, an intranet, or the Internet. To display helpful information when you rest the pointer on the link, click ScreenTip, type the text that you want in the ScreenTip text box, and then click OK. In the Text to display box, type the text that you want to use to represent the link. In the list under Defined Names, click the name that represents the cells that you want to link to, and then click OK. In the Or select a place in this document box, under Cell Reference, click the worksheet that you want to link to, type the cell reference in the Type in the cell reference box, and then click OK. To link to a location in another workbook, click Existing File or Web Page, locate and select the workbook that you want to link to, and then click Bookmark. To link to a location in your current workbook, click Place in This Document. On a worksheet of the source workbook, click the cell where you want to create a link. Note:В Names can't contain spaces and must begin with a letter. If you want to create a link to a specific location in the file or on the web page, click Bookmark, and then double-click the bookmark that you want. To locate a web page, click Browse the Web, open the web page that you want to link to, and then switch back to Excel without closing your browser. To enter the name and location of a known file or web page that you want to link to, type that information in the Address box. To select a file that you recently used, click Recent Files, and then click the file that you want to link to. To select a web page, click Browsed Pages and then click the web page that you want to link to. You can change the current folder by selecting a different folder in the Look in list.

To select a file, click Current Folder, and then click the file that you want to link to. Under Link to, click Existing File or Web Page. You can also right-click the cell or object and then click Link on the shortcut menu, or you can press Ctrl+K. On the Insert tab, in the Links group, click Link. You can also select an object, such as a picture or an element in a chart, that you want to use to represent the link. On a worksheet, click the cell where you want to create a link.

Hyperlink not working in excel vb net