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

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

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