OPENING HYPERLINKS IN EXCEL

S

Santi

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

Gary''s Student

Try this small macro:

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

Santi

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?
 
Top