ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   attach macro to hyperlink (https://www.excelbanter.com/excel-programming/274686-attach-macro-hyperlink.html)

Rohit Thomas

attach macro to hyperlink
 
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

Rohit Thomas

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

.



All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com