Macro to Launch URL

gmooney

Board Regular
Joined
Oct 21, 2004
Messages
242
Office Version
  1. 365
Platform
  1. Windows
Hi,

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

VBA 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?
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

EFANYoutube

Active Member
Joined
May 19, 2017
Messages
278

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?


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.
 
Solution

Forum statistics

Threads
1,143,836
Messages
5,721,082
Members
422,339
Latest member
SHIVATVM

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top