Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 1st, 2006, 08:40 PM
Authorized User
 
Join Date: Jun 2006
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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






Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening a text file using hyperlink in a gridview absu General .NET 1 March 6th, 2009 02:03 AM
Accessing text in a hyperlink field mvyjim ASP.NET 2.0 Professional 0 March 10th, 2007 05:22 PM
dynamic text for hyperlink goldenstate ASP.NET 2.0 Basics 0 February 28th, 2007 01:03 PM
chart object as anchor for hyperlink kritimehrotra Excel VBA 3 July 28th, 2006 06:01 PM
Conditionally display text object leo_vinay Crystal Reports 1 April 18th, 2006 07:22 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.