object vs text hyperlink
Hi,
I have textboxes created from the Drawing toolbar, which I have turned into a hyperlinks by right-clicking and adding a destination from there. I also have regular text hyperlinks in my workbooks. All destinations are cells within the same workbook, sometimes on the same worksheet, sometimes to a different worksheet.
My problem: I have code under the Workbook_SheetFollowHyperlink and the Workbook_SheetActivate events. For some reason, these events seem to be triggered ONLY WHEN the link followed is a text link, not when I click on the text-box links. Even the SheetActive event is not triggered although the textbox hyperlink is to a different sheet.
Why would this be?
Please help!
Thank you,
Kriti
|