hyperlink to separate cells in a different workbook
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.
--
Gary''s Student - gsnu200793
"dmfw" wrote:
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" wrote:
Place the picture on the sheet
Right-click the picture and then Assign Hyperlink
--
Gary''s Student - gsnu200793
"dmfw" wrote:
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
|