SSR

You can use the Worksheet_FollowHyperlink event. You can limit when the
event runs by testing the Target argument. So if you have multiple
hyperlinks, but only want the code to run when one of them is clicked, you
can use an If statement like these

If Target.Address = "C:\My Documents\" Then

or

If Target.Range.Address = "$A$1" Then

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Srinath" wrote in message
...
Hello,

I have a Single hyperlink in a cell. This Hyperlink is pointing to a
Folder
on the drive. What I want to know is this.
Is it possible to run a particular piece of code once I click on the
hyperlink?. It does not matter if the folder is resolved and opened but I
want to run a piece of code which check for a particular file in another
Drive Folder and opens that file(.doc) depending on some conditions.



Regards,
SSR