Picture Hyperlink Path

[tom]

I have a worksheet with a column of "pictures." All that the user sees
is the text Picture, with that text hyperlinking to an image on a
network share thusly: "file:///\\server\share\imagename1" or
"file:///\\server\share\imagename2", etc.

There are two things that are throwing me:
1) When a different user opens the workbook on a different PC, that
image path changes to reflect that user's My Documents path. How do I
create a static path?
2) I need to edit each of those image paths, adding a directory path to
each. For example, where they all read
"file:///\\server\share\imagename", I need them to read
"file:///\\server\share\newdirectory\imagename"

Any help is greatly appreciated.

-tom

 

[Tom Ogilvy]

Update the hyperlinks with code.

Possibly in the workbook_open event.