Bob Phillips
12/12/2006 9:51:00 PM
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.
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"ISUTri" <GraberJ@gmail.com> wrote in message
news:1165959486.248153.65310@73g2000cwn.googlegroups.com...
> 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
>