Wallstreetgol

1. Microsoft Word Hyperlink Return
2. Microsoft Word Hyperlinks Not Working

Linklocation 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. The path can be to a file that is stored on a hard disk drive.

Adds a hyperlink to the specified range or shape.

Install Office for Mac now Unmistakably Office, designed for Mac Get started quickly with new, modern versions of Word, Excel, PowerPoint, Outlook and OneNote—combining the familiarity of Office and the unique Mac features you love. Feb 08, 2016 In this video, you’ll learn the basics of working with hyperlinks in Word 2016. Visit for our text-based. Jul 03, 2017 This article describes how to create absolute hyperlinks and relative hyperlinks in Microsoft Office Word 2010, in Microsoft Office Word 2007, and in Microsoft Office Word 2003. More Information Word automatically creates a hyperlink when you type the address of an existing Web page, such as www.microsoft.com, into a document.

Syntax

expression.Add (Anchor, Address, SubAddress, ScreenTip, TextToDisplay)

expression A variable that represents a Hyperlinks object.

Parameters

Return value

A Hyperlink object that represents the new hyperlink.

Remarks

When you specify the TextToDisplay argument, the text must be a string.

Example

This example adds a hyperlink to cell A5.

This example adds an email hyperlink to cell A5.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

Note

Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.

Symptoms

When you create a hyperlink in an Office document and then select the link, you may receive one of these error messages:

Unable to open <URL>. Cannot locate the Internet server or proxy server.

Unable to open <URL>. Cannot open the specified file.

<URL> = the hyperlink you inserted.

Note

The hyperlink does work if you type it directly in the browser or in the Open box of the Run dialog box (select Start, and then select Run).

Cause

This problem occurs when the following conditions are true:

• You are using Microsoft Internet Explorer:

  • A proxy server -or-
  • A firewall that does not allow HTTP requests to be placed on your local network

• Internet Explorer is not your default browser.

• The ForceShellExecuteregistry key is not present in the following location or is not set to 1:

  For 32 bit Office Versions installed on 64 bit OperatingSystems

  HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftOffice9.0CommonInternet

  For 32 Bit Office Versions installed on 32 bit Operating Systems or 64 Bit Office Versionsinstalled on 64 bit Operating Systems

  HKEY_LOCAL_MACHINE SoftwareMicrosoftOffice9.0CommonInternet

Workaround

Important

This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, select the following article number to view the article in the Microsoft Knowledge Base:

322756 How to back up and restore the registry in Windows

To have us work around this problem for you, go to the 'Here's an easy fix' section. If you prefer to fix this problem manually, go to the 'Let me fix it myself' section.

Here's an easy fix

To fix this problem automatically, select the Download button. In the File Download dialog box, select Run or Open, and then follow the steps in the easy fix wizard.

• This wizard may be in English only. However, the automatic fix also works for other language versions of Windows.
• If you're not on the computer that has the problem, save the easy fix solution to a flash drive or a CD, and then run it on the computer that has the problem.

Let me fix it myself

To work around this issue, either add the ForceShellExecute subkey, if it is not present, and set the Value data, or if it is present, set the Valuedata of the ForceShellExecute subkey.

Adding the Internet Subkey to the Registry and Setting the Value Data

1. Quit any programs that are running.

2. select Start, and then select Run. Type regedit in the Open box, and then select OK.

3. In Registry Editor, browse to one of the following subkey (create the keys when they do not exist):

   For a 32 Bit version of Office on 64 bit version of Windows

   HKLMSOFTWAREWow6432NodeMicrosoftOffice9.0CommonInternet

   For a 32 Bit version of Office on 32 bit version of Windows

   HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice9.0CommonInternet

   For a 64 Bit version of Office on 64 bit version of Windows

   HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice9.0CommonInternet

4. Make sure the Internet subkey is selected. On the Edit menu, point to New, and then select DWORD Value. Add the following registry value:

   Value Name: ForceShellExecute

5. Double-click ForceShellExecute, and then set the Value data to 1. Select OK.

6. On the Registry menu, select Exit.

Did this fix the problem?

Check whether the problem is fixed. If the problem is fixed, you are finished with this section. If the problem is not fixed, you can contact support.

More Information

A hyperlink may not go to a Microsoft Word document or a Microsoft Excel worksheet after you use this workaround.

Office uses the Urlmon.dll file to handle all Internet transitions.

In this case, the Urlmon.dll file sends a request to get a file via http:// through the proxy server. The proxy server sees that the request came from Internet Explorer, based upon the HTTP User Agent field of the http://request. It then gives an error 403, basically saying 'Access Denied.'

The Urlmon.dll file gets this and simply returns the error message mentioned earlier. The error means that the request failed, but it never states why it failed.

Microsoft Word Hyperlink Return

Microsoft Word Hyperlinks Not Working

The workaround is to simply use a ShellExecute() on the URL. This allows the operating system to start the URL on the default browser. If the default browser is not restricted by the proxy server, the proper page is displayed.