Event triggers

[cram]

Hi all,
I need to have an event triggered in Excel in a specific worksheet when a cell is selected (one of several possible hyperlinked cells). Any thoughts on setting up event handlers?

thx,
Cram

 

[RobBroekhuis]

In that particular worksheet, add a

worksheet_selectionchange

event handler. Then check the actual location when it triggers:

sub worksheet_selectionchange
if target.address=range("MyLinkCell&quot.address then
...do your stuff here...
end if
end sub

Rob