hi,

in excel I have a list of file names I have in a folder. my excel file is also in this folder.
I carry this folder to different locations on my computer from time to time. here is the question.

is it possible to write a macro that looks where the excel file is, conjugates with the file list I have, and turn them into hyperlinks, and colors the hyperlink different if the file doesn't exist in the folder.

It would be great if you can help,

Thanks