Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use a hyperlink to display a selection of cells on another sheet (in same workbook) | Excel Discussion (Misc queries) | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
Issuing macro in workbook from separate workbook | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) |