I approached a similar problem with an OnTime event to periodically poll the
cell. This was a DDE app. I don't reccomend this approach.

Is there any way you can trap the event in book B instead??
--
Gary''s Student - gsnu200720


"Riddler" wrote:

I have 2 workbooks one called "A" and the other "B". THere is a cell
in a worksheet in workbook "B" that hyperlinks to a cell in workbook
"A". When a change is made to the cell in book "A" the hyperlink in
book "B" updates to show the change. My problem is that I want to run
a macro when the cell in book "B" changes. The problem is I can not
find a event that is triggered when this update is made to book "B". I
can run code when book "B" is activated by me looking at it and such
but I want code tied directly to the updating or refreshing of a
specific hyperlinked cell. The before hyper link event on a worksheet
only works if you are clicking on a hyper link to go to it or
something. I dont want to have to click on anything.

If someone can help me with this hyper link problem I would sure
appreciate it.

Thanks
Scott