can you code an Event Change macro to only run if certain cells are changed in a worksheet rather than any cell
Not as far as I know. The change event handler will fire for every change. You have to monitor the cells you are interested in manually. You already have the code you need ... perhaps you just need to move it to the start of the module.