Hi,

I'm working on a complex spreadsheet with many sheets and need to
know
if something I do in any sheet causes a particular cell value in the
first sheet to change.


I've played around with onevent macros but they seem to be triggered
only if a cell changes content rather than changing value. ie. a cell
is deleted or overkeyed, rather than a formula just giving a
different
value.


Can anyone assist with the code I need to do this?


Many thanks and Merry Christmas to all.


Kind regards,


Ana