hyperlink to separate cells in a different workbook
 

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

hyperlink to separate cells in a different workbook
 

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

hyperlink to separate cells in a different workbook
 

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

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

hyperlink to separate cells in a different workbook
 

Thank you! It worked perfectly.

"Gary''s Student" wrote:

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