VBA usage & workbook not responding

**Zaeguzah** · 02-01-2010, 05:51 AM

Hi everyone,

I found this script on ozgrid and it works well except when I use hyperlinks to other sheets. The hyperlinks have custom names and the cell where the hyperlinks leads, contains another hyperlink back to the first hyperlink. (if needed i'll supply an example book).
The problem is that when i click on such a hyperlink, the workbook goes crazy, doesn't respond to any command and uses the cpu up to a maximum.
Any ideas why it's acting this way?

Please Login or Register  to view this content.

Thanks for all the help so far,
Alex

**DonkeyOte** · 02-01-2010, 06:21 AM

A sample file might help yes.

Questions

a) how are the hyperlinks created - manual or via functions ?

b) if created manually - are you using the FollowHyperlink event at all ?

In essence I can't replicate the perpetual loop you're experiencing irrespective of how the links are created - however - if there were another event taking place somewhere that might help explain things.

**Zaeguzah** · 02-01-2010, 07:17 AM

Hi Donkey,

I honestly don't know. The sample workbook contain the exact model of hyperlinks that i use in the real book. As for the loop, there is nothing that I can think of. I don't use any kind of events in the workbook only some volatile udf's.

Thanks for looking into it.

**DonkeyOte** · 02-01-2010, 07:27 AM

Are you able to replicate your issue in the sample flie ? I can't (once I add in the code you outlined earlier)

We need to see the real thing - or at least a version that contains all event based code and the hyperlinks.