Proton, I have a question. Tab "Checksheet" has in Column A the list of file/picture links in the files we have uploaded. The file you uploaded Macro wording help(bvj).xlsm‎ has 2 tabs, "Checksheet" and "Checksheet(2)".

When I move my mouse icon to the links in column A of "Checksheet", they display the link path location. When I move my mouse icon to the links in "Checksheet(2)", the links display the link path location of where they are located relative to tab "Checksheet", not relative to the link path location. Was that done on purpose?

Also, when I run the "Create Hyperlinks" Macro, I keep on getting a Run-time error:

Invalid procedure call or argument at the following line:
"IDName = Left(JPGList.Cells(Ctrl + 1, "A").Value, Len(JPGList.Cells(Ctrl + 1, "A").Value) - 4)"

Any idea what that is for?
GetFileNames macro works as you coded it with no errors.
Create_Hyperlinks has the error on the line of coding listed above.