View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Opening a Hyperlink using macros

Lets say there is a hyperlink in cell D7:
http://www.microsoft.com
then:

Sub hypergoer()
ActiveWorkbook.FollowHyperlink Address:=Range("D7").Value
End Sub

--
Gary''s Student - gsnu200745


" wrote:

Does anyone know how to open a hyperlink without using your mouse?
I've tried a couple of macros but I can't get them to work. I am
inexperienced with Macros (especially the VBE ones) Any help would be
MUCH appreciated as it would save me a great deal of time.
Thank you,
Patrick