attach macro to hyperlink
Dave,
Thanks very much for the response. It's works just the way
I wanted it to.
Rohit
-----Original Message-----
Maybe you can use the event: Worksheet_FollowHyperlink
But it'll fire after the link gets started.
(Rightclick on the worksheet tab that contains the
hyperlink (the hyperlink is
in a worksheet???), select view code and then select
worksheet in the left hand
header and followhyperlink in the right hand header.
Put a little msgbox in there to see if it comes close to
what you want.
Rohit Thomas wrote:
Hello All,
Is it possible to attach a macro to a hyperlink. If the
answer is yes, how would I do it?
Thanks in advance,
Rohit
--
Dave Peterson
.
|