Use the FollowHyperlink Event. Right click on the sheet tab, select view
code, select it from the dropdowns at the top of the module.

--
Regards,
Tom Ogilvy


"CodeKid" wrote:

The code that I want to run is very simple -- it takes the text of the cell
containing the hyperlink and copies it a specific range. It also selects the
specific range.

For example -- a list of 300+ symbols in one column:

ABC
DEF
HIJ

The code I need will convert the text to a hyperlink (I have this part
solved) and when the hyperlink for any of the symbols listed is clicked, it
will copy, for example, "ABC" to another cell and select the other cell that
now contains the copied text.

Any help you can offer would be greatly appreciated!

-CodeKid