On Click Event in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ISUTri - 12 Dec 2006 21:38 GMT

Is there anyway I can have Excel run code on a single click in a cell?
What I'm trying to do is I have a spreadsheet that has hyperlinks in
it. However, I want it to run code when someone clicks on the
hyperlink before it sends the user on to the hyperlink. I've found
where I can do this with a double click but that doesn't do me any good
since the hyperlink only requires one click.

Thanks for any help

Reply to this Message

Bob Phillips - 12 Dec 2006 21:51 GMT

Use the FollowHyperlink event

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
'your code
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.

Signature

---
HTH

Bob

(change the xxxx to gmail if mailing direct)

> Is there anyway I can have Excel run code on a single click in a cell?
> What I'm trying to do is I have a spreadsheet that has hyperlinks in
[quoted text clipped - 4 lines]
>
> Thanks for any help

Reply to this Message