Otto,

I do not think there is a good solution to this, but here are some
suggestions that might be practical for small numbers of formulae:

- use a tracker function (similar to CalcSeqCountRef from my downloads page)
to track each cell and signal to the "something" that the cell has
changed/been recalculated. The problem is that this is probably only
practical for a few hundred cells before the overhead gets too large.

- use a shadow sheet that contains the values at the end of the last
calculation. Use the Sheet Calculate event to compare the values looking for
differences to trigger the "something" and then rewrite any changed values
into the shadow sheet.

The tracker function approach would work best if only a small number of
cells change at each calculation, or the number of changes per minute is not
large. The shadow sheet works best for batches of updates.

Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com