hyperlink to separate cells in a different workbook

  • Thread starter Thread starter dmfw
  • Start date Start date
D

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
 
Place the picture on the sheet
Right-click the picture and then Assign Hyperlink
 
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!
 
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.
 
Thank you! It worked perfectly.

Gary''s Student said:
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.
Click to expand...
 
Back
Top