I actually have 2 different spreadsheets doing different things but
have the same bottle neck. One of them has a dynamic link to a PLC
(programable logic controller) on a machine in a factory. Every time
the machine produces a bad part a error code is entered and when this
happens the spreadsheet automatically detects this error entry and
displays a series of ascii codes. I have a cell with a formula that
then "decodes" these asciii numbers into text to be able to read the
error. What we are wanting to add is a time stamp to each error. So
when a error is entered on the PLC the spreadsheet sees this and
updates and calcuates the text message from the ascii numbers and then
puts a time stamp in the cell next to it. I have been able to get the
calculate event to show but I dont get the target reference of what
changed in the recalc.
The other similar case is with 2 spreadsheets that are hyperlinked.
When a new name is put in a cell I want it to show in the second
workbook and then rename the sheet tab in the second book also. The
problem is capturing a event that happens when a hyperlink updates.

Scott