View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul James[_3_] Paul James[_3_] is offline
external usenet poster
 
Posts: 58
Default how to tell which hyperlink was clicked

I've got several hyperlinks in a worksheet, and I would like to run some VBA
code in the FollowHyperlink event of the worksheet. However, I would like
to use a series of "If" statements that test to see which of the several
hyperlinks was clicked, so I can set different lines of code to correspond
to the different links.

How do I test to see which of several different hyperlinks was clicked in a
worksheet.

(Tom or Dave - can you help me with this one too?)

Thanks in advance,

Paul