Activating Hyperlinks in multiple cells

Hello all

fredlo2010 has created this wonderful code for me which pretty much turns everything A2 and below into a hyperlink that is linked to its specific file in the terminal server

Please Login or Register  to view this content.

it works like a charm BUT I have to activate each link by clicking into the cell then clicking out of it or pressing F2 then enter. sadly there are thousands of cells in this workbook. is there an easy way to activate all of them?

possibly a macro that can do it? thanks in advance

Hi..

Try this..

Please Login or Register  to view this content.

thank you very much for your help, however it doesn't work, I tried putting it in a command button and it didn't turn them into hyperlinks

Hi..

It works here.. try the attached file.. and adapt as necessary to your own situation..

tyvm appreciate it