View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rohit Thomas Rohit Thomas is offline
external usenet poster
 
Posts: 21
Default 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

.