The documentation for FollowHyperlink suggests that rather than simply handing off the URL to your browser for it to load, the function actually downloads the data within Excel and then hands the downloaded data off to the browser instead. You might have more luck with
Shell("rundll32 url.dll,FileProtocolHandler " & URL)