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
Maybe this macro will help.
Sub Refresh() For N = 1 To ActiveSheet.Hyperlinks.Count If Dir(ThisWorkbook.Path & "\" & ActiveSheet.Hyperlinks(N).Address) = "" Then ActiveSheet.Hyperlinks(N).Range.Font.ColorIndex = 3 Else ActiveSheet.Hyperlinks(N).Range.Font.ColorIndex = 4 End If Next N End Sub
Martin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks