hyperlink to separate cells in a different workbook

[dmfw]

Is it possible to hyperlink a bitmap image in one cell in one workbook to
open and/or highlight directly to a specific cell in a second workbook?
These workbooks will reside in the same folder? If possible, say these two
workbooks were to be downloaded to a different compter, would the hyperlink
remain active? Thank you?


Best regards

 

[Gary''s Student]

Place the picture on the sheet
Right-click the picture and then Assign Hyperlink

 

[dmfw]

THANKS FOR YOUR REPLY. MY QUESTION IS THIS, WHEN I AM ASSIGNING THE
HYPERLINK, WHAT PATH, ADDRESS, OR SPECIAL CHARACTERS DO I NEED TO TYPE TO
OPEN TO A SPECIFIC CELL IN A SEPARATE .XLS FILE? I DON'T WANT TO JUST OPEN
ANOTHER .XLS FILE, I WANT IT TO OPEN TO A SPECIFIC CELL OR SHEET. THANK YOU!

 

[Gary''s Student]

In the Address field type something like:

file:///c:\temp\visit me.xls#Sheet3!Z100

This will goto the file (and open it if necessary) and then goto the correct
sheet and cell.

 

[dmfw]

Thank you! It worked perfectly.

In the Address field type something like:

file:///c:\temp\visit me.xls#Sheet3!Z100

This will goto the file (and open it if necessary) and then goto the correct
sheet and cell.