View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Santi[_2_] Santi[_2_] is offline
external usenet poster
 
Posts: 15
Default OPENING HYPERLINKS IN EXCEL

Gary,

You're a great help this worked!!!

Do you know if maybe I can add to the macro below and automated fuction that
after opening all hyperlinks at once it can also attached all images into an
email without having to go thru each image and attaching them?

"Gary''s Student" wrote:

Try this small macro:

Sub hypper()
Dim h As Hyperlink
For Each h In ActiveSheet.Hyperlinks
h.Follow
Next
End Sub

--
Gary''s Student - gsnu200797


"Santi" wrote:

IS IT POSSIBLE TO OPEN SEVERAL HYPERLINKS IN A WORKSHEET ALL AT ONCE INSTEAD
OF CLICKING ONE BY ONE?? CAN ANYONE HELP?