Picture Hyerlink Path
Hello -
I am no experience with this element of Excel, so I hope I make myself clear enough. 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 |
All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com