Hi, ckarra,

code goes behind the sheet which you want to monitor and will get started on any direct change to a given cell/range or via Query. You would not need to start that macro by hand and will not find it listed int the macro list.

If the macro won´t get fired please make sure that events have been enabled in Excel by entering into the Immediate Window in the VBE
Application.EnableEvents = True
and hit Enter (of course make any macro available in the workbook as well).

Ciao,
Holger