Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi!
How can i go 1 step back from a hyperlink object even if it is to another workbook? I create hyperlinks with code, and then i want to follow it. Thats not a problem. Then i want a new macro to get back from that link to the previuos even if it is another workbook. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You mean that workbookA opens workbookB with a hyperlink and you want
WorkbookB to know where the link came from ? If so, no possible AFAIK, as the destination has no knowledge of where the link came; it is told open by windows, so it does. NickHK "Mogge" ... Hi! How can i go 1 step back from a hyperlink object even if it is to another workbook? I create hyperlinks with code, and then i want to follow it. Thats not a problem. Then i want a new macro to get back from that link to the previuos even if it is another workbook. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello NickHK!
But way thas it work when push web link back. "NickHK" wrote: You mean that workbookA opens workbookB with a hyperlink and you want WorkbookB to know where the link came from ? If so, no possible AFAIK, as the destination has no knowledge of where the link came; it is told open by windows, so it does. NickHK "Mogge" ... Hi! How can i go 1 step back from a hyperlink object even if it is to another workbook? I create hyperlinks with code, and then i want to follow it. Thats not a problem. Then i want a new macro to get back from that link to the previuos even if it is another workbook. |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Yes beacuse the application (Excel or your web browser) is keeping a list of
the places you visit. But each file does not know where it is in that list. It is just "open" or "not open". What are you trying to achieve ? NickHK "Mogge" ... Hello NickHK! But way thas it work when push web link back. "NickHK" wrote: You mean that workbookA opens workbookB with a hyperlink and you want WorkbookB to know where the link came from ? If so, no possible AFAIK, as the destination has no knowledge of where the link came; it is told open by windows, so it does. NickHK "Mogge" ... Hi! How can i go 1 step back from a hyperlink object even if it is to another workbook? I create hyperlinks with code, and then i want to follow it. Thats not a problem. Then i want a new macro to get back from that link to the previuos even if it is another workbook. |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
OK.
I have one workbook, that containes hyperlinks to a sheet in that workbook or another workbook. I want to get back one step in the hyperlinks. "NickHK" wrote: Yes beacuse the application (Excel or your web browser) is keeping a list of the places you visit. But each file does not know where it is in that list. It is just "open" or "not open". What are you trying to achieve ? NickHK "Mogge" ... Hello NickHK! But way thas it work when push web link back. "NickHK" wrote: You mean that workbookA opens workbookB with a hyperlink and you want WorkbookB to know where the link came from ? If so, no possible AFAIK, as the destination has no knowledge of where the link came; it is told open by windows, so it does. NickHK "Mogge" ... Hi! How can i go 1 step back from a hyperlink object even if it is to another workbook? I create hyperlinks with code, and then i want to follow it. Thats not a problem. Then i want a new macro to get back from that link to the previuos even if it is another workbook. |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello!
When i push the link web link arrow back it always return both to right workbook and sheets. "NickHK" wrote: You mean that workbookA opens workbookB with a hyperlink and you want WorkbookB to know where the link came from ? If so, no possible AFAIK, as the destination has no knowledge of where the link came; it is told open by windows, so it does. NickHK "Mogge" ... Hi! How can i go 1 step back from a hyperlink object even if it is to another workbook? I create hyperlinks with code, and then i want to follow it. Thats not a problem. Then i want a new macro to get back from that link to the previuos even if it is another workbook. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hyperlinks: Hyperlinks change on copy/paste? | Excel Worksheet Functions | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! | Excel Discussion (Misc queries) | |||
Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) | |||
Hyperlinks to =Hyperlinks formula - Challenging | Excel Programming |