Followhyperlink Freezing

JerryGiese

Active Member
Joined
Jun 27, 2005
Messages
323
I have a sheet that contains tracking numbers for shipments. I setup a macro so when I double click the tracking number, I combines the tracking number with the tracking site url and uses followhyperlink to open the tracking information in internet explorer. Normally it opens internet explorer within about 3 seconds. The problem is that about 1/3 of the time, when I double click the tracking number, it will freeze for about 1-5 minutes. Then, when internet explorer finally opens, excel will unfreeze. It seems to be getting stuck on the followhyperlink method. Does anyone know what could be causing this or how to fix it?

Thanks,
Jerry
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,119,185
Messages
5,576,582
Members
412,735
Latest member
jwoods1204
Top