If you put it in the worksheet code module, per the instructions, the
macro will fire whenever a cell in the sheet is changed manually.

In article ,
"Tony4X4" wrote:

Thanks for the quick response. Stupid question! When does the code get
executed? I tried pressing F9, or do I have to change something?