OPENING HYPERLINKS IN EXCEL
 

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

OPENING HYPERLINKS IN EXCEL
 

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?

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?