Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink History
I have a worksheet with a number of hyperlinks to cells in that worksheet.
At any point I can always travel back from link to link using the Back button on the Web toolbar. I am assuming that Excel maintains some kind of history list of the links that have been clicked. How can I get to this list in VBA? -- jake |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink History
Hint: When having a programming issue record a new macro a see what excel
would do. go to the tools menu - macro and start recording a macro. the ctivate the hyperlink and perrform a back. Stop the macro and see what code excel produces. "Jakobshavn Isbrae" wrote: I have a worksheet with a number of hyperlinks to cells in that worksheet. At any point I can always travel back from link to link using the Back button on the Web toolbar. I am assuming that Excel maintains some kind of history list of the links that have been clicked. How can I get to this list in VBA? -- jake |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink History
The Recorder is of no help. Pushing the Back button records as a series of
Application.GoTos to hard addresses. I need to get to that list of addresses. -- jake "Joel" wrote: Hint: When having a programming issue record a new macro a see what excel would do. go to the tools menu - macro and start recording a macro. the ctivate the hyperlink and perrform a back. Stop the macro and see what code excel produces. "Jakobshavn Isbrae" wrote: I have a worksheet with a number of hyperlinks to cells in that worksheet. At any point I can always travel back from link to link using the Back button on the Web toolbar. I am assuming that Excel maintains some kind of history list of the links that have been clicked. How can I get to this list in VBA? -- jake |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
History ! | New Users to Excel | |||
Rollback history | Excel Discussion (Misc queries) | |||
IE history | Excel Programming | |||
History | Excel Programming | |||
History Archive | Excel Programming |