Hi all.

I have an excel file with some cells containing Hypertextual URL links.

These links are opened by a macro but sometimes the internet site is slow because it is down or in overload and excel crashes.

I try pressing esc button but it doesn't work, the screen become white and everything stops.

I was arguing if there is a way to unblock excel in these cases or maybe a code that I can insert in the macro so that it stops the loop after 10 seconds.

Thank you


__________________
You have never see gift ideas like these? (idee regalo on italian)

Pretty hard to help without a sample of the code. Why do you need a macro to open a URL link? Excel has this feature built in. Anyways if you have a loop you can set a variable startTime = now() then in your loop go now()-startTime(). I think now() is in seconds so then you just need to exit the sub at 10 seconds.

I suggest that you search or ask your question in the excel newsgroups at groups.google.com/group/microsoft.public...amming/topics?lnk=li it might provide a better quality/amount of responses.

For example, try to select this site from a cell:
www.hotvsnot.com

and to launch this macro:
Sub OpenLinks()
Dim rCell As Range
On Error Resume Next
Application.DisplayAlerts = False
With Selection
For Each rCell In Selection.Cells
ActiveWorkbook.FollowHyperlink _
Address:=rCell.Value, _
NewWindow:=True
Next rCell
End With
End Sub

my excel freeze!
how to unlock?

esc not work, ctrl+break not work..
ctrl+alt+canc works but but loses data

thanks

I resolved to adding DoEvents on the macro code
Thanks to all
Bye