VBA code for hyperlink VS link

[mss90]

Okay so I got a model in ArcGIS that find a lot of links, these links are then copied into a spreadsheet by a VBA script together with a lot of other data.
Then I got a line of code that finds these links

Please Login or Register  to view this content.

I noticed that my links are not actually defined as hyperlinks until I click them and hit enter, is there a code to recognize just http/html links or do they have to be active hyperlinks?

Thanks in advance

[Norie]

How are you copying the links into the cells?

Are they valid URLs?

[mss90]

How are you copying the links into the cells?

Are they valid URLs?

I will need to look into it when I'm near a pc, but yeah they are valid urls, but just not hyperlink (not blue text)

[mss90]

How are you copying the links into the cells?

Are they valid URLs?

Im using this code;

Please Login or Register  to view this content.

[mss90]

And this is the code to open the hyperlinks,

Please Login or Register  to view this content.

[mss90]

Could I manybe use; xlCellTypeAllValidation so that I could set a requirement of "http://"?
Maybe RegEx with something like this; /(??:https?|ftp|file):\/\/|www\.|ftp\.)(?:\([-A-Z0-9+&@#\/%=~_|$?!:,.]*\)|[-A-Z0-9+&@#\/%=~_|$?!:,.])*(?:\([-A-Z0-9+&@#\/%=~_|$?!:,.]*\)|[A-Z0-9+&@#\/%=~_|$])/igm