I have a Validate macro in a spreadsheet that checks several fields whenever
the Validate macro button
is clicked. Is there a way to call that macro any time any cell in the sheet
is changed or selected. The
clerks can't seem to click the button when they access the sheet. One of the
import validation checks it
does is check the Contact time for all rows which alerts us if a Tech hasn't
touched base with us within
the last 2 hours if his job is still open.

Thanks in advance...