How do I run a macro in the background

[scrumboss]

we need to run a macro in excel that will constantly check for changes in the
work book.
any help appreciated

 

[Ardus Petus]

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

in ThisWorkBook code

HTH

 

[Niek Otten]

http://www.cpearson.com/excel/events.htm