OPENING HYPERLINKS IN EXCEL

  • Thread starter Thread starter Santi
  • Start date Start date
S

Santi

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,

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Activating hyperlinks 3
Open specific hyperlink (accept) automatically in email with outlook 0
Will not auto open .jpg 1
When sharing, can I force an Excel document to open in a certain view? 0
Hyperlinks changed by Excel again! 5
Kiosk Mode Navigation 0
Hyperlink Function to Tab 4
Hyperlink to web does not return to original Excel worksheet 1

Back
Top