Macro to Launch URL

[gmooney]

Hi,

I have a shape in Excel that when clicked on fires of the following code:

Sub GetURL()

    Dim NewURL As String
    Dim FollowURL As String

    NewURL = ThisWorkbook.Sheets("Category Review").Range("AP107").Value
    ThisWorkbook.FollowHyperlink NewURL
    
End Sub

This code works fine on my 64bit laptop with 64 bit Office. I have a user with 64bit laptop and 32bit.

The error message she gets is Runtime error -2146697211 Cannot locate the Internet server or proxy server.

Thoughts?

 

[EFANYoutube]

Simple search shows there might be nothing wrong with the code but with the setting on the computer​

If you send her the hyperlink just in an excel cell, what happens when she clicks it?​

Cannot locate the Internet or proxy server when selecting hyperlink in Office - Office

Describes issues when you select hyperlinks in Office. Provides solutions.

docs.microsoft.com

​

Cause​

This problem occurs when the following conditions are true:

• You are using Microsoft Internet Explorer:
  • As a proxy server -or-
  • With a firewall that doesn't allow HTTP requests to be placed on your local network
• Internet Explorer isn't your default browser.
• The ForceShellExecute registry key isn't present in the following location, or isn't set to 1:
  • For 32-bit versions of office installed on 64-bit operating systems:
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\9.0\Common\Internet
  • For 32-bit versions of Office installed on 32-bit operating systems, or 64-bit versions of Office installed on 64-bit operating systems:
    HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0\Common\Internet
  • Note
    The registry path doesn't depend on your Office version.