Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

in ThisWorkBook code

HTH
--
AP

"scrumboss" a écrit dans le message de
...
we need to run a macro in excel that will constantly check for changes in
the
work book.
any help appreciated