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

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?

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?