I'm having a small problem with the way hyperlinks work in Excel 2003 and it is causing my macro not to work.

I have a spreadsheet of information, and all of the rows of info are linked the left most column of file names. I want these file names to link to their respective files on my computer.

My first idea was to highlight all the files, and link them all to (T:\files\TEMP.pdf) and then use my macro to change the word TEMP in all the hyperlinks to the hyperlinks .TextToDisplay.

In theory this should work, but the problem is that because I highlighted all the hyperlinks, they are all considered one hyperlink, and not 6000 hyperlinks. Therefore if I remove the hyperlink from the top file, they are all removed, and when my macro runs, it links all 6000 hyperlinks to what hyperlink #1 should have linked to.

Is there any way to make all of these hyperlinks seperate from each other? Or is there a better approach I should be using to do this?