I have thoroughly read all the posts on automatically running macros from a
change in cell contents. However, if the cell being tested has been updated
from MS query the macro doesn't run. I have checked this by over writing the
data returned from query and the macro runs. If I get the macro to run from
the cell change that invokes the query, the macro has done it's bit before
the data has been returned!