View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michelle Michelle is offline
external usenet poster
 
Posts: 204
Default FollowHyperlink causes error

I have some code that works fine, unless I have followed a hyperlink first.

I have built a form which all works correctly, and I have now added an image
which triggers a hyperlink in its click-event.
(ActiveWorkbook.FollowHyperlink Address:="http://www.myAddressHere.co.uk",
NewWindow:=True)

If I use the hyperlink, and then go back and try and continue using the
form, then nothing works, I get an error:
Method 'Range' of object '_Global' failed

it stops on this line
Set xRange = Range(rngRange)
where rngRange is a RefEdit control with a valid range reference in it - it
works fine if I haven't clicked the hyperlink first.

I could lose the hyperlink, but I'd really like to get to the bottom of
this. Any ideas?

Thanks

Michelle