how much more automated? when they blink ?
you mean you never open a cell and enter data on this workbook?
Workbook_Change works only with data, does not work if your range contains formulas..this is a far more complicated macro

maybe an expert will give you a better solution