Auto Hyperlink to existing cell value

In my file, a macro gets the file path to starting from B11 to B(n), meaning 1 ,1000 or 20.000 file name in B column.
Starting to B11 to B last row filling with path names, for example "E:\FILMs\The Thin Red Line.avi" etc. This is the full path of the file.

I need to make hyperlink for each row cell value with an additional macro codes which will make auto hyperlinks when first macro ended.

Like "Private Sub Worksheet_Activate()" or "Private Sub Worksheet_SelectionChange(ByVal Target As Range)"

Or any idea or code will be acceptable.

Thanks in advance for replies.

Regards,
turist

Waiting for any comment or solution.

Originally Posted by scott.s.fower

hey, so when you click the hyperlink do you want it to open or do you want it to open the folder that contains it?

I want to open the hyperlinked file (for example , if avi file in mediaplayer). NOT to open the folder.

k the code i gave you will open the file

Originally Posted by scott.s.fower

hey, so when you click the hyperlink do you want it to open or do you want it to open the folder that contains it?

right now it opens the file... (should be dependent on your default player)

replace your sub with this modified one

Please Login or Register  to view this content.

Dear scott.s.fower

Thanks a lot for your prompt reply.
It is OK, worked.

Regards,
turist