follow hyperlink

Hi all, As you know, when an hyperlink is clicked in excel or in other applications, its text color changes visually indicating that the link has already been followed. The color is reset to its default when re-opening excel. (Depending on the update automatic links at open setting) I am...

Hello, I was wondering if it's possible to create a hyperlink in Sheet1, that link it to a specific cell on Sheet2, AND also follow that cell whenever I add/delete rows on Sheet2? My dilemma is that I have a hyperlink created and link it to let's say Sheet2 cell E10. But later on when I add...

Hello Everybody, I need your help guys. I am trying to find hyperlinks in a column and open them in my default browser. I am currently using this: Sub openlink1() 'Open Links Dim Sh As Worksheet Dim Rng As Range Dim Cell As Range On Error Resume Next Set Sh =...

I have this macro, which I want to download all the files given by the hyperlinks in column a. The problem is that the line of code with the Choose function isn't working. Is there a way to enter an array as the value argument in Choose or another function that will let me do what Choose tries...