Take a look at FollowHyperlink Method in VBA's help.
It has a nice example.
Paul James wrote:
Thanks for the info, Tom.
Question: could you please say a few words about how to use a follow
hyperlink event?
I know how to create a Sub Procedure in the VBE, and I know how to assign
the procedure to a command button. But how do you "follow" a "hyperlink
event?"
Thanks again in advance.
Paul
"Tom Ogilvy" wrote in message
...
Use the follow hyperlink event to run the code.
--
Regards,
Tom Ogilvy
"Paul James" wrote in message
...
Is there any way to get a hyperlink to run a VBA sub procedure when you
click on the hyperlink?
Thanks in advance.
Paul
--
Dave Peterson