Jaafar Tribak
Well-known Member
- Joined
- Dec 5, 2002
- Messages
- 9,779
- Office Version
- 2016
- Platform
- Windows
Hi all,
As you know, when an hyperlink is clicked in excel or in other applications, its text color changes visually indicating that the link has already been followed. The color is reset to its default when re-opening excel. (Depending on the update automatic links at open setting)
I am wondering if there is a programmatic way of checking if an hyperlink has already been visited since the workbook was last opened.
I thought about using the Workbook_SheetFollowHyperlink event and tag the followed hyperlink(s) (using the Target argument) but I thought maybe there was a simpler more straightforward way, specially if the worksheets contain many hyperlinks.
Any thoughts.
Thank you.
As you know, when an hyperlink is clicked in excel or in other applications, its text color changes visually indicating that the link has already been followed. The color is reset to its default when re-opening excel. (Depending on the update automatic links at open setting)
I am wondering if there is a programmatic way of checking if an hyperlink has already been visited since the workbook was last opened.
I thought about using the Workbook_SheetFollowHyperlink event and tag the followed hyperlink(s) (using the Target argument) but I thought maybe there was a simpler more straightforward way, specially if the worksheets contain many hyperlinks.
Any thoughts.
Thank you.
Last edited: