Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2007

Tip: Looking for answers? Try searching our database.

How to generate links to pictures

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
msn - 18 Apr 2007 02:05 GMT
I need to link pictures together.
I have linked them as can be seen on this TEST:

http://www.ociw.edu/~ekoch/4star/BOM/TEST.pdf

My problem is that the links are fixed, they are to the first cell in the
page where the picture resides.
If I add pages of information or more pictures, then I have to reset all the
links.
Is it possible to use relative address to the pictures or better yet make
the link to a "label" on the picture? Or the picture name? So if I move the
picture the link is still valid.

I tried to solve this in another way. Placing pictures on another "sheet",
and I can link to a cell next to the picture on that sheet, BUT when I
convert the xls file to pdf the other sheets are invisible to the pdf
generator. But that might be a PDF problem.

Another solution that I am looking at is the generation of a text block as
in the red rectangle for example with the "Focal Plane Mechanisms" inside
that when clicked sends the user to a detail picture of that area. I created
that link within the PDF file, for ilustration purposes of what I am trying
to acomplish.  And this solution is not acceptable since every time I update
the xls file and create a new pdf, all the links in the pdf side would have
be re-created.

Thanks in advance,

Erich
Gary''s Student - 18 Apr 2007 10:36 GMT
Here is an idea to play with:

rather than inserting the picture on a worksheet location, insert the
picture in a cell comment.  That way the picture will be associated with a
specific cell.

Then set the hyperlink to point to that specific cell.

For inserting pictures:

http://www.contextures.com/xlcomments02.html#Picture

to hyperlink to a cell:

=HYPERLINK("#"&CELL("address",Sheet3!Z100),"target")

this will link to Sheet3 cell Z100 and will adjust if rows/columns are
added/removed.

Signature

Gary''s Student - gsnu200716

> I need to link pictures together.
> I have linked them as can be seen on this TEST:
[quoted text clipped - 25 lines]
>
> Erich
Erich Koch - 18 Apr 2007 16:34 GMT
Thanks, I'll give that a try.
Do you know why the PDF creation did not see the other sheets?

Erich

> Here is an idea to play with:
>
[quoted text clipped - 52 lines]
>>
>> Erich
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.