Sorry about the English, I can only read German!
-------------------------------------------------------------------------------------
Dear readers,
With the help of RAnton, I've managed to trigger a makro by changing a cell's value. Unfortunately, it does not work when the value is changed by a formule, as seen in the following examples.
Example:
I have a cell containing the formula =SECOND(NOW())
Everytime I press calculate (F9) the cell-value is changed, but the Makro isn't starting.
The same problem occurs when I change the cell-value through a DDE (Dynamic Data Exchange) connection
Is there anyone who can help?
Alex